How You Pull the records on daily basis into your ETL Server.

Answers were Sorted based on User's Feedback



How You Pull the records on daily basis into your ETL Server...

Answer / bharu_295

using incremental loading

Is This Answer Correct ?    4 Yes 0 No

How You Pull the records on daily basis into your ETL Server...

Answer / munireddy

uning incremental/delta/cdc..

for this we have so many logics some of them are..
using mapping level variable
using control table and ....

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


What are the circumstances that infromatica server results an unreciverable session?

1 Answers  


what is degenerated dimension?

1 Answers   IBM,


What is difference macros and prompts?

2 Answers  






How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


What is target update override

2 Answers   CTS,


How to improve the session performance in informatica?

3 Answers   Accenture,


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


what is dimension table?

17 Answers  


wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  


Explain joiner transformation in informatica

0 Answers   Informatica,


Categories