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 / ramakrishna
simple before targets put the sequence generator t/f enable cycle option put start value 1 and end vale 3 connect to all three target
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
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
Informatica Checkpoints
how many types of dimensions are available in informatica?
Which development components of informatica have the highest usage?
What are the different lookup cache(s)?
Where are the source flat files kept before running the session?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is an active transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is domain in terms of informatica?
Enlist the advantages of informatica.
can we override a native sql query within informatica? How do we do it?
How can you generate reports in informatica?
Explain about Informatica server process that how it works relates to mapping variables?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.