Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7802 Views
- I also Faced
- E-Mail Answers
Answer Posted / balakrushna
Hi Mukunda,
U r correct but, y u are using addional t/r Exp, without
EXP we will make this mapping scenario,
I made it actually, that is the way i am sending this
like as follow
SQ-Gen-|
|
Source--> SQL------>RTR->Target1
|
|--->Target2
In SQ-Gen:
Change the Startvalue, Endvalue and Check the CYCLE and
RESET option in the properties of SQ-Gen
popuklate the NEXTVAL from Seq_gen to RTR.
In the RTR t/r:
(as my scnario the 3 records will load tgt1 and next 3 will
load in tgt2 and next 3 will load in again TGT1 and so on..)
2 groups
one is NEXTVAL <= 3
and NEXTVAL >= 4
and populated these groups to ur target accordingly.
Thanks & Regards
Balakrushna
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
What are the differences between joiner transformation and source qualifier transformation?
What is informatica? Why do we need it?
What is the fact table?
Explain how many types of dimensions are available in informatica?
What is expression transformation?
Why sorter is an active transformation?
How to load last n records of file into target table - informatica
How big was your fact table
what is size of u r database?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is DR strategy for Informatica project?
Explain transaction control transformation in informatica
Explain in detail scd type 2 through mapping.
