Interested to Buy Any Domain ? << Click Here >> for more details...
What are the options in the target session of update
strategy transsformatioin?
- 2 Answers
- 10733 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Insert
Delete
Update
Update as update
Update as insert
Update esle insert
Truncate table
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / santhoshi
INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE
| Is This Answer Correct ? | 2 Yes | 1 No |
What is incremental aggregation?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Explain about HLD and LLD ?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
what is lookup ?
what is constraint based load order
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Define Incremental Aggregation?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
What is meant by lookup transformation? Explain the types of lookup transformation?
Teradata 
