what is flat file override?
Answer / guest
we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.
Is This Answer Correct ? | 11 Yes | 1 No |
what is lookup chache?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
how many session run unix environment what command using ?
what is constraint based load order
how can you load data into target table without leading zeor's
What are the new features in Informatica 5.0?
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 can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
Which transformation can be created only as reusable transformation but not as non-reusable transformation?