i have 1000 record flat file source i want 1st row to 1st
target, 2nd row to 2nd target, 3rd row to 3rd target how will
u do? Without using Mod Function? Explain....
Answer Posted / davankumar
1st take squence t/t conn expresion t/r to one out put port.
In sequence t/r enable cycle option and start value is 1
end value is 3 and increment by 1.
then take rouder t/r in 1st group nextval/3=0 then 1st
target,nextval/3=1 then take 2nd target then connect to
default group ok.. r u clear...
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Explain pmcmd command usage in informatica
What are the different components of powercenter?
what is index?how it can work in informatica
Explain the use of aggregator cache file?
What are the various types of transformation?
What are the types of schemas we have in data warehouse.
How many input parameters can exist in an unconnected lookup?
What are the types of lookup transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is diff b/t sorter t/r and agg have the option sorter property...
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the types of transformations?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is exclusive and normal mode for repository services?