What are the options in the target session of update
strategy transsformatioin?
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 |
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
what is inline view?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
What are the new features of informatica 7.1?
What are the differences between oltp and olap?
can anyone suggest best free Talend data integration training online