If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?
Answer Posted / basu
I think his question is, he wants to loads incremental. so you can go for Change data capture by using mapping variable/parameters in the SQ query overid
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a filter transformation and why it is an active one?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Differentiate between Load Manager and DTM?
What could be the possible resons of locks by user?
Whats there in global repository
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Reusable transformation and shortcut differences
Please let me know how to make encryption and decryption with example?
How do you load only null records into target?
Explain pushdown optimization and types in informatica
Mention some types of transformation?
can anyone suggest best free Talend data integration training online