Answer Posted / lokesh y g
suppose yesterday 100 got inserted into target,today 50
records inserted and 25 records got updateted ,rather then
pulling all records, using incremental logic we can pull
the data only updated records and inserted records using
setmax variable ........
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the uses of etl tools?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
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?
Explain why we use partitioning the session in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
tell me 5 session failure in real time how can you solve that in your project?
What differs when we choose the sorted input for aggregator transformation?
How to implement security measures using repository manager?
What is a sequence generator transformation?
Explain what transformation and how many are there in informatica?
how to load dimension table and fact table. plz tell me the steps.
How do you promote a non-reusable transformation to reusable transformation?
What is domain in terms of informatica?
Enlist some properties of sessions.