Interested to Buy Any Domain ? << Click Here >> for more details...
how will u load the data to diminision tables and fact
tables,what is the hiraraichy why we are using hirarichy
- 2 Answers
- 7358 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gm
You load dimension table before loading fact table. But
using Dynamic Lookup, you can load both simultaneously.
======
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abc
I think use the constraint load order and target load order
plan
| Is This Answer Correct ? | 0 Yes | 1 No |
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
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
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
Explain Dataware house architecture .how data flow from intial to end?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the main features of Oracle 8i with context to datawarehouse?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
Write the prerequisite tasks to achieve the session partition?
What is a sorter transformation?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
What is the difference between informatica 7.0 and 8.0?
Teradata 
