i have one table like
cust_id ph1 ph2 ph3
1002 9290123526 97671927210 9876545232
we use Normalizer wt is o/p?
sue normalizer we can generate three tables in single table/
- 4 Answers
- 6407 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ghouse
cus_id ph
1002 9290123526
1002 9767192210
1002 9876545232
| Is This Answer Correct ? | 2 Yes | 0 No |
In normalizer tab of normalizer tr. set no of occurence to 3
since we have 3 phno,which in turn create 3 i/p port in port tab,u hav to create exp tr. betn normalizer and target and map GCID_phno to expression tr. say out_phno and give condition in expression like decode(GCID_phno,1002,9290123526,1002,97671927210,1002,9876545232);
It might help u
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / subash
Hi Ghouse,
Can u pls explain how we achieve this, the logic in
normalizer, is it by just connecting the output ports from
normalizer to target , where we define ph1 occcuring 3 times
in normalizer transformation. Do we have to use any
expression transformation between the normalizer and the
target. Can some one who tried please explain the logic that
happens in normalizer transformation in splitting a single
row into multiple tuples
| Is This Answer Correct ? | 0 Yes | 0 No |
In development project what is the process to follow for an etl developer from day1
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
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 the use of source qualifier?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
What is source qualifier transformation in informatica?
In a sequential batch can you run the session if previous session fails?
What is critical mapping?
How informatica process data means how informatica works?
Teradata 
