Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
- 2 Answers
- 7912 Views
- iGate, Qualcomm, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / davankumar
Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / davankumar
Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables
| Is This Answer Correct ? | 3 Yes | 0 No |
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
Which is the best place to learn Informatica Powercenter Online Training?
what is difference between COM & DCOM?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What is an aggregator transformation?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is session task and command task?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
when we use dynamic lookup,if condition matches what will be the o/p?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
. 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
Define mapping and session?
Teradata 
