5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
1395How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
CTS,
1117What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
CTS,
1175how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
CTS,
1241I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
CTS,
1192What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
CTS,
1 1567can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
3311Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
1224what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
1765How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
HP,
1449In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
HP,
1 2402Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
IBM,
1309There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
1 2578Post New Informatica Questions
What is standalone command task?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Differences between version 7.x and 8.x.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
During the running session, output files are created by informatica server. Enlist few of them.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
expain about the tune parameters?
Enlist few areas or real-time situations where informatica is required.
What is an Integration service in Informatica?
What are the reusable transformations?
What are the different types of transformation available in informatica.
Can we create multiple integration service on single repository?
server hot-ws270 is connect to Repository B. What does it mean?