Answer / gvk

Here

SOURCE------>SQ--->AGG---> SEQ\ /T1
----->JOINER----->ROUTER----
SOURCE------>SQ--->EXP---> \T2


THIS IS THE PROCESS
HERE AGG--->TWO PORTS 1)NEW PORT 2)COUNT PURPOSE
EXP---->1)NEW PORT ONLY
JOINER-->COMPARE TO THE (AGG & EXP) NEW PORTS AND
APPLY THE FULL JOIN
ROUTER--->TWO CONDITIONS

Answer / mukunda

we have to follow the follwing pipe line

seq--|
SOURCE-->SQ-->EXP-->STOREPROCEDURE-->EXP--->ROUTER---->T1
|------>T2

Using store procedure we can count the total no of rows.
Using sequence genater we have to create the assign the
value to each row. Then find the max rowid using the srore
Procedure t/r. Then this result value store as 'n'. And
the wrire the conditon in router tranformation.
GROUP1--->N<=N/2--->connected to Target1
GROUP2--->N>=N+1/2--->Connected to Target2

*FOR exaple the source table is containg 99 records.
Using the store procedure we can find the count value n as
99.
Conditoin1-->N<=N/2(=44)44 records store in to target1.
Condition2--->N>=N+1/2(=45)-->45 Records store in to the
target2.


If you have any quires plese ask. mukunda.velluri@gmail.com

Answer / abhinaw prakash

Ypu can write this query in the SQL override.

select * from table_name where rownum < (select
max(rownum)/2) from employees).


Also you can write the same logic in Router and develop a
mapping.

Answer / masudul

Create a two flow mapping.
First Flow-

1.take the original source
2.inside Source qualifier write down the query

select * from (select * from tabl_name) where rownum <=(select count(key_column_name) from tabl_name)/2 );

then dump it to the target. this will take the first half of the entire source.

and in second Flow do the reverse thing..

Answer / triveni

first pipeline copy nextval port to expression
create one dummy outputport assign 1
second pipeline
deptno decimal 20
totalrecord decimal 10 0 count(deptno)
create another dummy port
dummy decimal 10 0 assign 1
joiner tr common port from 2 pipelines dummy
empno,dummy(detail),totalrecord,dummy1(master)
condition:dummy1=dummy
jointype:normal
router:
nextval<totalrecord/2
nextval>totalrecord/2

Answer / venu

s----sq------srt----rtr---t1
t2

inthis flow take two sequence generaters and connect to
s0rter t/f like this

nextvalue descending order enable
nextvalue1 asending order enable

for example if 6 records contain
the sort result would be

nextvalue nextvalue1
6 1
5 2
4 3
3 4
2 5
1 6

sorter contain these ports and remaing ports next pass these
ports to ruter t/f

nextvalue > nextvalue1 1st condition ---it give 1st 3rows
nextvalue < nextvalue1 2nd cond ---- it gives last 3 rows

Answer / sakthi

i think we can write sql query in first source qualfier and and select another source qualifier and write sql over ride query
1)select * from employees where rownum <= ( select count(*)/2 from employees);

2)select * from employees minus (select * from employees where rownum <= ( select count(*)/2 from employees));

Answer / mukesh

use router t/r

Answer / sudhakar

Take router tranformation,and creat two groups in that,in
first group write the condition-50<=100 and send
one target,2nd group write the
condition-1<=50 and send it to another target

Answer / balaji.r

Pass the first half of records to one source qualifier from
that pass to one target,pass the second half of records to
one more source qualifier and pass it to targets

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

Have you worked with/created Parameter file

0 Answers  

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

what is parallel querying and what r hints.

1 Answers  

How to add source flat file header into target file?

3 Answers   Logica CMG,

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

Explain the different lookup methods used in informatica?

0 Answers  

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

Explain pmcmd command usage in informatica

0 Answers   Informatica,