i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.
- 3 Answers
- 6602 Views
- I also Faced
- E-Mail Answers
Answer Posted / mukunda
Mapping structure
=================
source-->sq-->sequence-->exp-->router-->target1
|-->target2
1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups
Group1:nexval<=50-->this group conneted to target1
Groutp2:nexval>=50-->this group conneted to target2
or
default group connected to target2
Note: This logic only that source data contain 100 records.
If you any quires please ask.
Best Regards,
Mukunda
mukunda.velluri@gmail.com
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
In development project what is the process to follow for an etl developer from day1
Tell me about Propagate functions in informatica
EXL informatica Questions
How can we delete duplicate rows from flat files?
Enlist the tasks for which source qualifier transformation is used.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are ETL Tools?
Is there any way to read the ms excel datas directly into informatica?
What is a standalone command task?
Why sorter is an active transformation?
What is dynamic cache?
Enlist some properties of sessions.
