How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 9066 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / shyam
from source qualifier trf take a exp trf with a sequence gen
and from there give it to filer trf. write there a condition
next value<=4 and give it to update stategy trk. and there
give condion as dd_insert and then to targer,this all comes
in first pipeline.
in second pipeline drag the ports from exp trf and again
take a filter trf,over there give condion as next_val>4 and
next_val<9. give this to update trf and then to targer.
try this .i hope u vl get the o/p.
if im wrong plz let me know
shaym
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
is it possible to index the data in cache of lkp transformation ?
what is the size of u r source(like file or table)?
Explain the scenario which compels informatica server to reject files?
Explain load alternative records / rows into multiple targets - informatica
Whats there in global repository
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the tasks that source qualifier perform?
Enlist the various types of transformations.
What is the need of etl tools?
What is the difference between a connected look up and unconnected lookup?
Where is metadata stored?
In warehouses how many schemas are there?
How 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?
Informatica settings are available in which file?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
