Interested to Buy Any Domain ? << Click Here >> for more details...
Hey I am net to informatica? Can any one explain me step by
step How scd will work ?
- 1 Answers
- 7705 Views
- Infosys, I also Faced
- E-Mail Answers
Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.
| Is This Answer Correct ? | 6 Yes | 2 No |
How to load duplicate records in to a target table which has a primary key?
What is Data Caches size?
Explain one complecated mapping?
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 ?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How can u work with remote database in informatica?did you work directly by using remote connections?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
If we are using an aggregator but forget to mention the group by port .what will be the output??
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What are the measure objects?
Teradata 
