If you want to create indexes after the load process which
transformation you choose?
Answers were Sorted based on User's Feedback
Answer / bsgsr
stored procedure transformation can be used to create and
drop indexes before and after loading into the target.
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / kalyan
use the post session SQL to craete indexes on the target
table..
Is This Answer Correct ? | 11 Yes | 1 No |
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How to jion 2 tables, without using any condition?
can u any challenge your project?
without dynamic lookup transformation how to insert new rows and update existing rows?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
How identifying bottlenecks in various components of informatica and resolving them?
how to through logic of informatica using the push down optimization into oracle.
Why sorter is an active transformation?