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 / madhu
d_acctbal
d_party
d_account
d_adress
d_contact
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are junk dimensions?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Enlist the various types of transformations.
What is the sql query overwrite in source qualifier in informatica
Clarify the utilization of aggregator cache record?
What is different between the data warehouse and data mart?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain the aggregator transformation?
can anyone explain me about retail domain project in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a router transformation?
What is union transformation in informatica?