Interested to Buy Any Domain ? << Click Here >> for more details...
how to design mapping half of source table records into one
target and remaining half into another target
- 8 Answers
- 15291 Views
- ABC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / akash
There are 2 ways through which we can achieve this:
Through informatica transformations: Source Qualifier /
Aggregator and Expression
1. Take count through an aggregator or source qualifier.
Add a port (say record_id) from sequence generator to give
the record number.
Mark router condition as -
where record_id < = (count / 2)
send this group to one target and default group of router
to other target.
2. Use the following query in Source Qualifier:
SELECT KEY_field,
description,
(CASE WHEN ROWNUM <= ((SELECT COUNT(*) FROM TEMP_TABLE)/2)
THEN 1
ELSE 2
END) AS FLAG
FROM table_name
In the above key_field and description are the required
fields from source table.
The result will be of the type:
KEY_FIELD DESCRIPTION FLAG
1 ABC 1
2 JJJ 1
3 XYZ 2
4 PQR 2
Use a router on the condition of port FLAG to map data to
targets.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sbvp
raj this is my mail id bhanuar.inf@gmail.com.
chat with me on evening times 7-8
i will discuss with u
thanks
sbvp
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / neha
IT is not possible thru Informatica, you need to write Unix
Script for this.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / sbvp
hi raj
when we use source as a flat file
if a flat file contians 10 records assume ok
take seq gen t/r- next val
to exp t/r
in that add a new port and give seq gen-nextval to that new
port(suppose call as seq_num ok)
take RTR t/r
create two out ports ok
seq_num<=5
seq_num>=5
contect to two tgrts ok
thanks
sbvp
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / sbvp
S->SQ->EXP->ROUTER->TRG
| |
| |-->TGR
SEQ<-
IN RTR SEQ<=n
SEQ>=n
| Is This Answer Correct ? | 0 Yes | 3 No |
How to generate sequence numbers?
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.
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
Explain how many types of dimensions are available in informatica?
What is the Rank index port in Rank transformation?
What are pre and post-session shell commands?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
in a table it has 200 rows the query is select 150 from tablename.whats the output
Teradata 
