Interested to Buy Any Domain ? << Click Here >> for more details...
How to extract original records at one target & Duplicate
records at one target? {with out using EXPRESION
transformation and sequence generator transformation?}<-this
is important
- 4 Answers
- 10457 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / p1khatri
using Dynamic lookup :-
for new record (i.e. Newlookuprow =1)insert into tgt 1
for duplicate records (i.e. Newlookuprow=0) insert into tgt
2
I hope this'll work
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Plz can any one say me how to get the informatica certification materials and dumps
What do you mean by filter transformation?
Explain your project of banking domian.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference between a connected look up and unconnected lookup?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Why do you use Mapping Parameter and mapping variable?
what is the size of u r source(like file or table)?
What is joiner change?
explain one complex mapping with logic? sales project?
How do you convert single row from source into three rows into target?
What is rank index in rank transformation?
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,
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
can u give example for factless fact table
