Interested to Buy Any Domain ? << Click Here >> for more details...
suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
- 9 Answers
- 13123 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / koti
add seq generator to target. and make a look up to target..
then SQ--> Expr--> add two ports in expr. and define the
conditions as iif(sno<500,'true','false')-->router transf.
--> target and instance of target.
definetly it can works like SCD!
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
Explain the scenario which compels informatica server to reject files?
Describe the impact of several join conditions and join order in a joiner transformation?
Informatica settings are available in which file?
Implementation methodology
What is rank transformation?
What are ETL Tools?
Enlist the tasks for which source qualifier transformation is used.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
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
What is the Rank index port in Rank transformation?
How we can create indexes after completing the loan process?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the differences between joiner transformation and source qualifier transformation?
In development project what is the process to follow for an etl developer from day1
