Explain one complecated mapping?
Answers were Sorted based on User's Feedback
Answer / rao
normalizer transformation.which will performs normalized data.
ex:year q1 q2 q3
2006 10 20 30
2007 20 30 40
after performing the normalizer transformation the date
will be like this
year item sales
2006 1 10
2006 2 20
2006 3 30
like 2007 also
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / informatica_learner
upstare,Rao
this only use one nomalizer transformation
configure one item as occurs 3 is ok
it is easy
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram kumar
SCD 2 is one of the complecated mapping in informatica
| Is This Answer Correct ? | 3 Yes | 5 No |
where does the default group roew in a router is stored what is the default size of memory in router
What are mapplets?
write a query to retrieve the latest records from the table sorted by version(scd)
What is difference between a gateway node and worker node?
What is event and what are the tasks related to it?
How to merge First Name & Last Name?
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
What r the type of indexes u generally used in informatica?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
what is semi-additive fact?where did u used?
What are the session parameters?
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?