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)?
Answer Posted / lokesh
Table which contains account number,customer numbers.........
| Is This Answer Correct ? | 9 Yes | 12 No |
Post New Answer View All Answers
Where is metadata stored?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to update a particular record in target with out running whole workflow?
What is the use of an aggregator cache file?
Enlist few areas or real-time situations where informatica is required.
What is transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is persistent lookup cache?
What are pre and post-session shell commands?
Clarify the aggregator change?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is rank transformation?
Explain scd type 3 through mapping.