how will you remove the duplicate records from flat file
without using sorter?
Answer Posted / sathish
put primary key to target it will reject duplicate rows
|Is This Answer Correct ?||1 Yes||4 No|
What are the issues you have faced in your project? How did you overcome those issues?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Have you worked with/created Parameter file
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
In which scenario did u used Mapping variable?
What is an Integration service in Informatica?
How might one distinguish in the case of mapping is right or not without associating session?
What is the fact table?
How 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
What is persistent lookup cache?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can informatica load heterogeneous targets from heterogeneous sources?
explain one complex mapping with logic? sales project?
How to call shell scripts from informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?