how the data will be loaded while desiging the schema?which
one first (for e.g.-dimesions and facts)
Answers were Sorted based on User's Feedback
Answer / sree
dimension tables are loaded first and fact tables.As all primary keys of the dimension table is linked with the foreign keys of fact table for proper lookup we need to load dimension tables first.
| Is This Answer Correct ? | 7 Yes | 0 No |
The order of loading the schema is as below:
1)Dimension Table
2)fact table
| Is This Answer Correct ? | 5 Yes | 0 No |
Design time, run time. If you don't create parameter what will happen
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Differentiate between source qualifier and filter transformation?
can we override a native sql query within informatica? Where do we do it?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
when informatica 8 series released ?
What is a sorter transformation?
What are mapping parametres and variables in informatica?
how we load the data from source to staging area
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000