How do you implement unconn. Stored proc. In a mapping?
Answer / isha
http://www.folkstalk.com/2013/04/unconnected-stored-procedure-transformation-informatica.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
how to load dimension table and fact table. plz tell me the steps.
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
How we can create indexes after completing the load process?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How many cubes create from a single model?
Explain incremental aggregation in informatica
WHAT IS FACT TABLES?
How can we create index after completion of load process?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?