How to create mapping that half records will go to one target and half to another target?

vijayant.sanjay

 Profile Answers by vijayant.sanjay Questions by vijayant.sanjay

• Sep 7th, 2011

Use the sql override in source qualifier as select col1, col2, (select count(*) from table) from table;

In the mapping flag the rows into groups in router t/f as count(*) port count(*)/2

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

Create two source qualifier write a query in SQL override select * from emp where rownum in(select count(*)/2 from emp)another
SQL override write a queryselect * from empminusselect * from emp where rownum in(select count(*)/2 from emp)
To connect target

Answer Question  Select Best Answer

Gourav Mukhija

• Sep 7th, 2011

Flag are mostly use in Update Strategy Transformation. there are four flag which are manly used 1) INSERT (dd_insert or 0) 2) UPDATE (dd_update or 1) 3) DELETE (dd_delete or 2) 4) REJECT (dd_reject o...

Answer Question  Select Best Answer

Can any body suggest the practical example where mapping parameter or variable is used, Please suggest the same for session parameter and variable..?

Rajeev Das

• Sep 2nd, 2011

Mapping Parameter is a constant value which remains same throughout the entire session, whereas Mapping variable value keeps changing as many times we run the session. Senario (mapping parameter), ...

Answer Question  Select Best Answer

What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?

Read Best Answer

Editorial / Best Answer

anshu.gangwar  

 Profile Answers by anshu.gangwar Questions by anshu.gangwar

• Member Since Sep-2008 | Sep 30th, 2008

---

$ prefixes are used to denote  session Parameter and variables and $$ prefixes are used to denote mapping parameters and variables

SEHAJ

• Aug 18th, 2011

$-This is d symbol for server o inbuilt variable.

$$-this is the symbol for the variables o parameters which v create

sweetmann27

 Profile Answers by sweetmann27 Questions by sweetmann27

• Aug 10th, 2011

Hi,

$ is session parameter e.g $DBConnection
$$ is mapping parameter/variable e.g $$LASTRunDate

Thanks

Improve Answer

Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?

Read Best Answer

Editorial / Best Answer

sasi.a.kumar  

 Profile Answers by sasi.a.kumar Questions by sasi.a.kumar

• Member Since Aug-2009 | Aug 14th, 2009

---

Router is an Active Transformation, Most of the time we use router only when we are going to apply multiple conditions on a records, It is absolutely possible for a record to satisfy one or more conditions thus making the router Active, Router is the only active transformation where the number of?output records from the transformation is greater or equal to the number of input records given to the transformation.

bosna

• Aug 17th, 2011

AS PER INFORMATICA DOCUMENTATION, Router transformation is ACTIVE and CONNECTED.. Please Don't thumb down if you're not sure..

RANJAN RASMI DAS

 Profile Answers by RANJAN RASMI DAS Questions by RANJAN RASMI DAS

• Jan 12th, 2011

Router can act both active and passive, one example....Suppose in source we have recordsid.....name -----------10.....aa10.....bb20.....cc20.....dd30.....xx40.....yy We have one target table...

Improve Answer

Supose we have 4 column based on same condition can we use unconnected lookup in that case?

Yoganand

• Aug 9th, 2011

Hi,

We can pull any number of columns in unconnected lookup nut with the help of Lookup override. We can concatenate many columns and then use an expression to deconcat those values.


Thanks,
Yoganand

Nagaraju Puppala

 Profile Answers by Nagaraju Puppala Questions by Nagaraju Puppala

• Feb 9th, 2011

Yes it's Possible.Suppose the look up table contains the group values, and the primary is a combination of EMP_NO, DEPT_NO.to get the EMP_NAME from the unconnected lookup, we should pass the EMP_I...

Answer Question  Select Best Answer

Ranga Rao

• Aug 4th, 2011

1.you should give the database connection
2.you should provide associated port for all look ports
3.cache size is less
4.not check the dynamic cache option in the properties tab

varun

• Jul 16th, 2011

Can you explain it more clearly means you are saying that the session fails when it is trying to returns more values or more columns

Answer Question  Select Best Answer

Explain the pipeline partitioning with real time example.

sumit dabas

• Aug 3rd, 2011

Pipeline partitioning consist of a long pipe cut(partitioned from between),there r many kinds of pipe..............

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 5th, 2010

Pipline partitioning in Informatica is similar as we have threading concept in Operating System. Here we divide data reading, writing and data transformation in more than one thread such that system c...

Answer Question  Select Best Answer

Sumanth

• Aug 3rd, 2011

In session properties use the header option and select header output field name

Rakesh

• Jul 28th, 2011

This is a way in informatica itself, follow the below step

In session level, click Edit - > Mapping - > select the tgt file - > goto Header Option -> select 'Output Filed Names'

We are done... u ll find the header names in the flat file. :)

cheers
Rakesh

Answer Question  Select Best Answer

malla reddy pannala

• Jul 25th, 2011

staging area is just like parking area before we entering the dwh here we doing here collecting the data from various data bases like oracle,db2, teradata to a single data base any of them, remove dup...

noverino

 Profile Answers by noverino Questions by noverino

• Feb 23rd, 2007

Staging area is temporary area used by ETL to do "Transformation" process. It could be anything, namely database, flat file, memory (cache), complex file, etc. In ETL, there's minimal 3 area: Source, Staging, Target (DW/DM).

Answer Question  Select Best Answer

hi, hi can anybody answer my query... that is i had a source table containing for eg;D1,D2,D3,D4,D5 one by one that means in a each column contains single source i.e., D1 in 1st col,D2 in 2nd col so on now i want in my target like D1-D2 in one col, D1-D2_D3 in other col,D2_D3-D4 in other col and D3-D4-D5 in other col plz send as soon as possible.......... thanx in advance

Ashish

• Jul 23rd, 2011

Use expression transformation to get the desired output

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

One can pass the input through the expression, where the variable/output ports can be configured to pass the combined value by using the CONCATENATION function of informatica.

Answer Question  Select Best Answer

Can any one please tell me how to explain Data warehouse project in interview and from where to start and end. what to explain completely in it(data warehouse project), how much hast to explain from it(dw project) and what is architecture of it and data flow and construction of dw project or data warehouse.

what is data warehouse methodology ,types of dw methodology, most using dw methodology...

shilpa

• Jul 20th, 2011

Hi , when interviewer asks this question , it means he/she is asking about your current project work/task requirement. So u may tell from requirement gathering to the report generation. or u may proba...

Answer Question  Select Best Answer

What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?

naga durga prasad

• Jul 20th, 2011

Mapping can be designed with complex transformations
mapplet contains simple mappings

naveen

• Jul 12th, 2011

Mapplet is a part of mapping ! Mapplet is designed by using one active n more passive transformations..

Answer Question  Select Best Answer

sppk

• Jul 18th, 2011

The update transformation/strategy uses the concept of keys, in order to update the target table. As flat file do not have any Keys defined on it, it is not possible to update the target,. which is a flat file.

Noel Lastra

 Profile Answers by Noel Lastra Questions by Noel Lastra

• Apr 9th, 2008

You can modify the flat file using shell scripting in unix ( awk, grep, sed ).Hope this helps.

Answer Question  Select Best Answer

One source is flat file and other source is oracle, then how do you do the mapping?

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

There are two possible ways of doing it: 1) Both used in a single mapping with single pipeline(Joiner can be used, in order to join both the source in the mapping) 2) Use two different pipelines in a ...

xitij7185

 Profile Answers by xitij7185 Questions by xitij7185

• Jun 13th, 2011

With joiner transformation .

Answer Question  Select Best Answer

On one day there are 10 cities and the other day 5 more cities gets added? then how do you change the transformation? What do you do?

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

If there is change in the data, there is no need to go for changing of the transformation. Instead you can insert/update the incremental data.
Please elaborate the question if not answered.

Answer Question  Select Best Answer

rajesh

• Jul 14th, 2011

Using look up we can perform following 1.=,2.,4.=,6.!= also
But joiner 1.=,2.master outer,3.detailed outer,4.full outer

krishna

• Jul 12th, 2011

Lookup Transformation will perform Non_Equi Joins

Answer Question  Select Best Answer

Yes. By using Metadata reporter we can generate reports in informatica.

srinivas.j.abinitio

 Profile Answers by srinivas.j.abinitio Questions by srinivas.j.abinitio

• Jul 1st, 2011

Yes.?with using informatica Reporting too is informatica Analyzer.Thanks&Regards,Srinivas.

KarthikeyanVCSS

 Profile Answers by KarthikeyanVCSS Questions by KarthikeyanVCSS

• Jun 30th, 2011

Yes. It is Possible through Metadata Reporter

Answer Question  Select Best Answer

srinivas.j.abinitio

 Profile Answers by srinivas.j.abinitio Questions by srinivas.j.abinitio

• Jul 1st, 2011

Hi ,Look up transformation does not replaces with using joiner transformation.because joiner return multiple matching values but look up can't return multiple matching values(look up policy multiple m...

xgeneration

 Profile Answers by xgeneration Questions by xgeneration

• May 25th, 2008

as u mensioned that a joiner transformation can be used to work out the functionality that of look-up using master outer join,but what if the source is from different database & source from dff da...

Answer Question  Select Best Answer

What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys?

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Jun 8th, 2011

For such type of Join we can use INNER JOIN, The best example for this is when we fetch data from a flat file source and the date for which the data has to be fetched is taken from a table known as jo...

hundwanipankaj

 Profile Answers by hundwanipankaj Questions by hundwanipankaj

• Apr 5th, 2010

Dimension table types 1. Slow changing dimensions 2. Junk dimensions 3. Confirmed dimension 4. Degenrated dimension

Answer Question  Select Best Answer