Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 30919 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dwhlabs
1> using dynamiclookup concept
2> using variable concept
First solution
source > sorter >dynamic lookup > filter > Target1 and
Target2
for more abt informatica mappings ... www.dwhlabs.in
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
What is repository manager?
How can you differentiate between powercenter and power map?
What is the commit type if you have a transaction control transformation in the mapping?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How do you use reject loader.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Why do you use Mapping Parameter and mapping variable?
Informatica settings are available in which file?
what is the -ve test case in your project.
What is confirmed fact in dataware housing?
What is meant by incremental aggregation?
