In Flat file
Input is
A
B
C
I need output like this
A
A
A
B
B
B
C
C
C. How will u achieve this?
Answers were Sorted based on User's Feedback
Answer / abhinaw prakash
We can use normalizer for this.
send the ports from SQ to Normalizer.
In Normalizer put the occurrence of the incoming column as 3.
Connect the only column from SQ to the 3 incoming port in
Normalizer.
Connect the O/P column from Normalizer to target.
Is This Answer Correct ? | 20 Yes | 0 No |
Answer / moorthy, g
Hi All,
SRC-SQ-JAVA-TGT
In Java Transformation:
on Input row:
you have to add
for(int i=0;i<3;i++)
{
IN_NAME=OUT_NAME;
generateRow();
}
this is the simple way... we can do this.
Best Regards,
Moorthy. G
http://manthiramoorthy.blogspot.in/
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / jyothi
source s1
take 3 instance of Target(
t1
/
/
s1---exp----t2
\
\
t3
load data we will get record as mentioned in output
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / ankur saini
to make this simple from sq--take 3 expressions---add union
to take data from theses three expressions
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / jyothi
source s1 contains input data (A B C)
take 3 flows in mapping
create 3 instances for the target.
ex: target is T .Instances for T are t1 t2 t3
t1
/
/
s1---exp---t2
\
\
t3
load the data into targets using target load strategy
then we will get output as above
Is This Answer Correct ? | 0 Yes | 3 No |
what is dimension table?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
complex mapping ur project u r invlve can u explain and give real time example give me ?
what is the use of Java Transformation in Informatica 8.x?
how to run the batch using pmcmd command
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
what is SDLC way of code development?