How do you avoid duplicate records with out using source
qualifier,expression,aggrigator,sorter and lookup
transformations ?
- 4 Answers
- 10335 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / triveni
rank transformation
ex: empno,ename
1,ramu
1,ramu
2,rani
2 ,rani
empno(group by),ename(returnport) top1 or bottom1
target: 1 ramu
2 rani
| Is This Answer Correct ? | 14 Yes | 0 No |
What 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).
What are the types of data that passes between informatica server and stored procedure?
i have two source data there is no pk,fk how to join the two sources
can any one explain me about junk dimension
what is fact table?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
Can we create out put ports in source qualifier t/r?
What are the reusable transforamtions?
How to load the data from people soft hrm to people soft erm using informatica?
What if the source is a flat-file?
Teradata 
