How to load source into target 2 times?

rangarao.dwh

 Profile Answers by rangarao.dwh Questions by rangarao.dwh

• Jan 9th, 2012

For this Question I can provide four answers
1. By using union Transformation
2. Connect target two times to two source
3. By using Target load plan
4. By using Java transformation

Note: All of the methods works only when the target having no Primary key or Unique Key.

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

hi, we cannot use router transformation because router transformation is condition dependent and data is stored into multiple target. For using push-down optimization(Source-Qualifier) data is stored...

Answer Question  Select Best Answer

What are limitations and delimitations of Joiner Transformation?

jyothi_rayala

 Profile Answers by jyothi_rayala Questions by jyothi_rayala

• Feb 28th, 2011

Joiner transformation cannot be used in the below scenarios ? Both pipelines begins with the same original data source. ? Both input pipelines originates from the same source qualifier. ? Bo...

Ishita_dts

 Profile Answers by Ishita_dts Questions by Ishita_dts

• Feb 26th, 2011

No active transformation should be there upstream the joiner.

Answer Question  Select Best Answer

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

I have two target tables,so i want to make Union of both the target,so please let me know about this

santanu

• May 11th, 2012

Make two flows in the same mapping:
flow 1: load both the targets
flow 2: use both the targets as the source and use SQL override to join the tables. Then load them into a single table

Sreedhar Lokaray

• Nov 3rd, 2011

I think your question is how to merge the records from two targets after they got loaded? If this is your question then first import the two target tables as source tables. Complete the mapping to loa...

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Dec 20th, 2011

In Stored Procedure transformation we can also specify when the SP should run.Its Normal,Pre-load of the Source,Post-load of the Source,Pre-load of the Target and Post-load of the Target. Pre-load of...

Anubhav Raikar

• Nov 15th, 2011

If you are asking this in terms of Stored Procedure Transformation, then the SP would be run before the Source fetches any data (in case you select Source PreLoad) .. and in case of Source PostLoad th...

Answer Question  Select Best Answer

Suppose in my mapping 3 pipelines are there from source to target and i want to run the middle pipeline only.

Suhel Shaikh

• Nov 24th, 2011

Example; If we have two pipelines in a single mapping then whichever pipeline you do want to run just add 1=2 in the SQ override as a last statement.And create two sessions for the same mapping and add this statement to the SQ of one source which you don't want to run.It will run the other one.

SEHAJ SHANGARI

• Aug 18th, 2011

In designer.
Select mapping tab
There is a property target load plan
Select the source qualifier and the target which u want to run the first n place it in first position. Followed by other pipelines

Answer Question  Select Best Answer

vizaik

 Profile Answers by vizaik Questions by vizaik

• Oct 25th, 2011

Excel source is possible through File DSN - Target XML also can be done - read the documentation or help for more information

kumar

• Oct 21st, 2011

First we need to save the excel file in csv file and then we have xml transformation in informatica by using that we can convert csv file to xml file

Answer Question  Select Best Answer

ash.singh1790

 Profile Answers by ash.singh1790 Questions by ash.singh1790

• Jul 13th, 2014

1. Session Properties
2. Under General Options ---> Check "Enable Test Load" ---> Insert 10 in "Number of rows to test"

Mayur

• Jun 19th, 2014

In Session property we have one option that is Performance data check, if you click that option you it will give transformation wise result.

Answer Question  Select Best Answer

Can you update target as a flat file, without using updated strategy trasformation

Khota

• Jun 5th, 2013

You cannot update a flat file

veena

• Mar 8th, 2013

Yes we can update target without using Update Strategy Transformation in
session->mapping->target->treat source rows as
Update
Update as Update
Update else insert
Update as Insert

Answer Question  Select Best Answer

How do you validate the no of rows received in source with footer(count) and if both count matches then only it should load to target?

vijay

• Jan 6th, 2014

Design a mapping with 2 flow.1 to load the data into target with all necessary columns.2nd target will have only count information and set a target load plan as said above.In the session level. Set th...

saurav

• Apr 4th, 2013

You can utilize the MD5 hash functionality within the mapping

Answer Question  Select Best Answer

Vikas Nandal

• Apr 21st, 2013

Create a Dummy Port in both tables and assign same value e.g. 1 to both ports in expression transformation before joiner.
Now in join condition use this dummy port to join both tables.

anshuman trivedi

• Mar 3rd, 2013

You join these table using null key.

Pass {} to the key,I am sure it will work.

Regards,
Anshuman

Answer Question  Select Best Answer

source: target:
col1 col2 col1 col2

a 1 1 a,b,c,d
b 1 2 p,q,r
c 1 3 x
d 1
p 2
q 2
r 2
x 3

how to do this...

Thanks,
krishna.

rashmi

• Aug 12th, 2017

We can use aggregator transformation.say col1=Nme,col2=ID
Make new_name and new_no as variable port.Specify condition as New_name=IIF(new_no=ID,new_name||,||name,name)
new_no=ID
Give one output port say Output_name =New_name

suresh

• Apr 30th, 2017

I have to pivot the source data from column to rows till "transform" value, "transform" value can occurs any one of the columns, please advice me suggestions, Can any one help me how to achieve the be...

Answer Question  Select Best Answer

Source:
col2 col1
a 1
b 1
c 1
d 1
p 2
q 2
r 2
x 3

how to do this...
thanks
krishna

Manjunath

• Apr 9th, 2015

Converting rows into columns is de-normalizing, you may have to use aggregate transformation to do so. Note: vice verse is normalizing the data, that can be done using normalizer transformation. U...

Shiva

• Jan 14th, 2015

Pivoting means converting rows to column and vise verse.

Please use normalization transformation to achieve this.

Answer Question  Select Best Answer

Under what conditions selecting sorted input in aggregator will still not boost session performance ?

Venkateswara Rao

• Oct 14th, 2014

If all the rows belong to the same data group . Then it doesn't improve anything

Knonw

• Sep 16th, 2014

If in session property Incremental agg. is enabled. 2. in case of Nested aggregation 3. if treat row as data driven is selected in session property. In all of above cases aggrigator performance wil not be boosted up though its using sorted i/p.

Answer Question  Select Best Answer

Design mapping to load the first record from a flat file into Table A, the Last record from a flat file into Table B, and remaining record into Table C

Nagendra

• Nov 5th, 2015

Append Seq Gen after SQ, add sorter, make it desc based on Sequence generated and use a variable to make first row as 0 then by using router route SEQGEN = 1 to A (First Row), Variable =0 to B (Last Row) and rest to C

sum

• Oct 8th, 2015

Use aggregator to take count of rows; then again join this aggregator to source pipeline using dummy columns. Now add one sequence generator and add next_val as srnum from it to each source columns...

Answer Question  Select Best Answer

If both source have same rows, same number of columns and no duplicate which one should be choosen to be master in joiner trasnformation

Kiran

• Feb 2nd, 2016

When we drag first source into a joiner, Integration services treat them as detail, later source when dragged into the joiner, it is treated as master, There is one more check may b we can consider,...

kiran

• Nov 14th, 2015

Integration service can calculate the least number of records that should be in a master

Answer Question  Select Best Answer

Which of the following statements is correct on workflow events?

1) A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping.

2) A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon...

Visal

• Aug 14th, 2016

Event wait will be completed once the specified event occurs or in other words, it will wait for the event-raise activity to raise that particular event. You can create an event-raise to poll for a ...

milind

• Jul 12th, 2016

There are options which we have to select eg. to delete file after reading etc.,

Answer Question  Select Best Answer

vishal taywade

 Profile Answers by vishal taywade Questions by vishal taywade

• Sep 22nd, 2008

We can place source file any where in network, but it will consume more time to fetch data from source file, but if the source file is present on server srcfile then it will fetch data from source upto 25 times faster than previous.

abhishek_upadhyay

 Profile Answers by abhishek_upadhyay Questions by abhishek_upadhyay

• Sep 18th, 2008

Basically the flat file should be stored in the src folder in the informatica server folder.Now logically it should pick up the file from any location but it gives an error of invalid identifier or no...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: srinvas vadlakonda

• Sep 28th, 2006

---

Source name
Database location
Column names
Datatypes
Key constraints

srikanth

• May 11th, 2022

Column names

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 12th, 2009

ODBC data source, username, owner name, password. Once the connection is established, select the table.

Improve Answer

It is a repostitory object that generates,modifies or passes data.

sprajarajan

 Profile Answers by sprajarajan Questions by sprajarajan

• Aug 8th, 2008

A TransFormation Is a Repository Object.That Generates,Modifies or Passes Data.The Designer Provides a Set of Transformations That perform Specific Functions.For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.

bibhu

• Nov 10th, 2006

Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.

Answer Question  Select Best Answer