Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / remesh
BY USING INCREMENTAL LOADING CONCEPT
GO TO SESSION PROPERTIES--->
IN THAT U FIND OPTIONS INITIAL VALUUE AND INCREMENT VALUE
IN THAT U CAN INITIALIZE THE VALUES
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain the difference between a data warehouse and a data mart?
r u done any partitions in ur project?
What is olap (on-line analytical processing?
How will the document be delivered to me?
What is flashback table ? Advance thanks
What is update strategy transform?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Enlist the various types of transformations.
Design a mapping to load a target table with the following values from the above source?
Explain the types of lookup transformation?
What is the use of an aggregator cache file?
Does an informatica transformation support only aggregate expressions?
What is data transformation manager process?