1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi Experts,

I have a source table like this.

Name Number
Raj 2
Ram 1
Sam 2
John 1


In the target I need the ouptput like the below

Raj
Raj
Ram
Sam
Sam
John

We dont know the number value . It will be changing as n..

Please help me regarding this.


Thanks,
Nataraj V

Question Posted / ganesh kumar

Answer Posted / ganesh kumar

BY USING QUERY OVERRIDE IN SOURCE QUALIFIER
TO WRITE THE QUERY LIKE THIS

T_TEST UR SOURCE TABLE, NAME AND N_NUMBER UR SOURCE TABLE
COLUMN.

USING THE LEVEL PSEUDOCOLUMN TO GENERATE THE DUMMY ID(LEVEL
L)AND USING THE QUERY(DUAL TABLE) AS A INLINE VIEW AND THEN
JOIN(NON EQUIJOIN) THE CONDITION. FINALLY WE GOT THE RESUL

select t.name,t.n_number from t_test t,(select level l from
dual connect by level <= (select max(n_number) from t_test))
u where t.n_number>=u.l order by t.name;

SAME LOGIC USED FOR OTHER THAN RELATIONAL SOURCE AND THE
TRANSFORMATION.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How big was your fact table

1325

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1472

What is parallel processing in informatica?

1033

What are the different types of transformation available in informatica.

641

What is joiner change?

686




What are pre and post-session shell commands?

748

Separate from an archive server and a powerhouse?

499

Explain lookup transformation in informatica

650

What is option by which we can run all the sessions in a batch simultaneously?

667

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1679

How would you copy the content of one repository to another repository?

563

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640

Briefly explain the aggregator transformation?

604

Explain the tuning lookup transformation - informatica

615

How might you approve all mappings in the archive all the while?

605