Interested to Buy Any Domain ? << Click Here >> for more details...
hi all
my source looking like below
column1 column2
101,102,103 abc,def,ghi
1001,1002,1003 a,b,c
i want my target is
column1 column1
101 abc
102 def
103 ghi
1001 a
1002 b
1003 c
any one can you help
- 1 Answers
- 4535 Views
- I also Faced
- E-Mail Answers
Answer / fiero
Is the number of values in each column going to be a constant (i.e. 3 in this case)? If yes, there are couple of ways to do it.
Option 1:
Pass column 1 and 2 to an expression transformation.
Use string functions to determine the positions of commas in column 1 and store the values in individual output fields (e.g. 101 in field 1, 102 in field 2, etc). Do the same with the column 2 values.
Pass the individual o/p fields to a normalizer to transform the columns into rows.
Option 2:
Since the values are separated by comma, you can choose to write column 1 to a flat file target. Do the same with the column 2 values.
Then, use the files created from step 1 as CSV (delimited) file sources and use normalizer to transform them into rows.
Note: Normalizer will work only if the number of columns is known. If the number of columns can vary during run time, then you will have to think of something else.
| Is This Answer Correct ? | 3 Yes | 1 No |
Tell me about Propagate functions in informatica
what is mapping override?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
Is snow flake or star schema used? If star schema means why?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
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
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How will you convert rows into columns or columns into rows
What is a rank transform?
How to delete duplicate row using informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
where is the reject loader .
Teradata 
