On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
Answer Posted / sasi
the best way to do this use the slowy changing dimension in
the mappings-->wizzard-->slowly changing dimension-->type1
here u need to select the source and target tables.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
draw informatica architecture 8.6 ?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is option by which we can run all the sessions in a batch simultaneously?
How do you convert single row from source into three rows into target?
my source is junk data how will u remove that junk data by using unix please any one replay me
what are 3 tech challenges/ common issues you face?
Is it possible to define a single node as a Gateway node as well as worker node?
Does an informatica transformation support only aggregate expressions?
What are connected or unconnected transformations?
COM components can be used in Informatica
What are active transformations.
What are the conditions needed to improve the performance of informatica aggregator transformation?
generate date / time dimension in informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?