Send a Message
to anutwinkle

Comments

2

Joined

Mar 11, 2013

anutwinkle Profile

Forums Owned

Recent Posts

Informatica

Number of records in target based on dept count

Hi, The source data is shown below: Code: Ename, Deptcount ------------------ Mark, 3 Henry 2 Chris 1 In the target table, i want the output according the dept count. I want to repeat Mark 3 times, Henry 2 times and Chris 1 time in the target. The data in the target should look as Code: Mark, 3 Mark, 3 Mark, 3 Henry 2 Henry 2 Chris 1 Create a mapping to solve this informatica problem. With Regards anu  (Mar 11, 2013 | post #1)

Informatica

generate time dimension using informatica

Hi, The source contains the number of years(For eg:50). You have to generate a time dimension using informatica and load the data into the target. Generate the time dimension starting from year 2000 to the number of specified years in the source. With Regards, anu  (Mar 11, 2013 | post #1)