My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
Answer Posted / punitha
sr=>sq=>sq=>router=>target
in sequence generator,end value=10
enable cycle option, in router first condition nextvalue=1
another condition next value=10 ,take two targets for two onditions
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the difference between STOP and ABORT options in Workflow Monitor?
Differentiate between source qualifier and filter transformation?
Explain the types of transformations?
What do mean by local and global repository?
What is the need of an ETL tool?
COM components can be used in Informatica
differences between service based and product based?
What are the different types of repositories created using informatica?
What is InformaticaPowerCenter?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is the size of u r source(like file or table)?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the tasks that can be performed using sq?
Explain in detail about scd type 1 through mapping.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?