Answer / subbu

by using the date coll in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.

Answer / praveen

Taking the Target defination as source and using the joiner
and update we can do the incremental loading


2.By using lookup transformation, keeping lookup on target
and companring.

Answer / tshiwela

you can perform increamental load by using auxiliary
parameters.

Answer / sudhakar

BY USING MAPPINING VARIABLES,FIRST DEFINE THE VARIABLE
E.DATE AND NEXT COMPARE E.DATE,IF IT MATCHES THEN DATA
AUTOMATICALLY LOADED.

Answer / sagar chowdary

By using the date column in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
With this in mind, I will expect a load pattern like this

Every extract from the source will be a full load
Every load in terms of records, will be equal to last load + new records – deleted records
80-90 % of the extracted records will already exist in the valid table instance
Every load will be incrementally larger than the previous load, as more records are added to the sourceThinking

Answer / vaschiky

Disable truncate target table option from session target
table properties.

Answer / v

using increamental aggregration

Separate from an archive server and a powerhouse?

0 Answers  

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

what is runtime variable?

3 Answers   TCS,

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

Is stop and abort are same in informatica?

0 Answers  

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

what is flat file override?

1 Answers   Cap Gemini, HP,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

in which situations do u go for snowflake schema ?

2 Answers   TCS,

Explain how to import oracle sequence into informatica?

0 Answers