how can u avoid duplicate rows in flat file?
Answer Posted / ramanaiah
without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a dimensional model?
Write the program through which the records can be updated?
What is workflow monitor?
How can we use batches?
Explain why we use partitioning the session in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain your project of banking domian.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Scheduling properties,whats the default (sequential)
How to differentiate between the active and passive transformations?
which one is better performance wise joiner or look up
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is status code in informatica?