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

An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.

kvrp461

 Profile Answers by kvrp461 Questions by kvrp461

• Aug 18th, 2010

Connected: The transformation is?participated in the flow of data from source to target.Unconnected: The transformation is not?participated in the flow of data from source to target.

chandrarekha

• Sep 12th, 2007

Connect Transformation :A transformation which participates in the mapping data flow Connected transformation can receive multiple inputs and provides multiple outputsUnconnected : A unconnected...

Answer Question  Select Best Answer

For populating and maintaining data bases.

soundarinfosis

 Profile Answers by soundarinfosis Questions by soundarinfosis

• Jul 11th, 2008

can you give me a real time scenario please?

bneha15

 Profile Answers by bneha15 Questions by bneha15

• Apr 18th, 2007

We use a stored procedure transformation to execute a stored procedure which in turn might do the above things in a database and more.

Answer Question  Select Best Answer

hanimi

 Profile Answers by hanimi Questions by hanimi

• Apr 28th, 2011

Bulk load the dwh server bypass the data to the target, in that we have session performance improves.in normal load data moves the database log file.

Ray

• Mar 22nd, 2006

Also remember that not all databases support bulk loading. and bulk loading fails a session if your mapping has primary keys

Answer Question  Select Best Answer

Rajan Raorane

 Profile Answers by Rajan Raorane Questions by Rajan Raorane

• Oct 21st, 2010

Scenario in which when a load of 1000 records is loaded into the target and 100 records are bad records, those hundred goes to badfile dir which mention Session and the rest of the 900 should load to ...

sreenivasareddy.aug10

 Profile Answers by sreenivasareddy.aug10 Questions by sreenivasareddy.aug10

• Jul 10th, 2009

Error HandlingSometimes a stored procedure returns a database error, such as “divide by zero” or “no more rows”. The final result of a database error during a stored procedure ...

Answer Question  Select Best Answer

here are some of the interview questions i could not answer, any body can help giving answers for others also. thanks in advance.Explain grouped cross tab?Explain reference cursorWhat are parallel query's and query hintsWhat is meta data and system catalogWhat is factless fact schemaWhat is confirmed dimensionWhich kind of index is preferred in DWHWhy do we use DSS database for OLAP tools

Pavan Amaraneni

• Nov 24th, 2006

The Default Index type for DWH is bitmap(non-unique)index

Prasad

• Jul 14th, 2006

Hi,Rest of the answers are given by friends earlier.DSS->Decision Support System.The purpose of a DWH is to provide users data through which they can make their critical besiness decisions.DSS data ba...

Answer Question  Select Best Answer

Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Jun 8th, 2011

First of all alter the old target table in oracle and create another new table using query as CREATE TABLE  new_table  AS SELECT * FROM old_table, now import this table into the ta...

padamalacharan

 Profile Answers by padamalacharan Questions by padamalacharan

• Aug 25th, 2010

If the target is flatfile 'check' the option at session level:"append if exists"

Answer Question  Select Best Answer

Hi,Can you please tell me whether Informatica 7.1.1 powercenter version can be installed on windows XP professional. Iam trying to install both client and server on the same machine.But when Iam trying to create a system DSN from Source Analyzer menu, the application gets terminated it self.Please advise me if it should work.Thanks,

mr.kishorev

 Profile Answers by mr.kishorev Questions by mr.kishorev

• Feb 9th, 2010

Yes, you can install the power center 7.1.1 in windows XP,1. Create a new user account in Oracle. and give grant and commint previliges to that account.2. Configure informatica server by giving the de...

kolli.siva

 Profile Answers by kolli.siva Questions by kolli.siva

• Dec 26th, 2006

YES, u can install INFORMATICA POWER CENTER 7.1.1 version on WINXP.It works fine.check out once by creating a new DSN.

Answer Question  Select Best Answer

Ruhi

• Feb 4th, 2016

The header or footer can be created in the target using the property "append if exist" Depending on what you need in the header / footer and target data create our mapping. Example 3 flows of data So...

lakshmi

• Nov 7th, 2012

Hi..
As uma told...she is rite,but may i know how to create footer in a flatfile

Answer Question  Select Best Answer

Could anyone tell me why session fails when running a workflow? I do not see any records being inserted to target table though source table has data. There are sufficient permissions to the user who is running workflow and relational connections are pointing to the correct databases. This whole exercise is taking place on windows xp pro and backend database is oracle 10 EE. Any help is appreciated.

rohit1505

 Profile Answers by rohit1505 Questions by rohit1505

• Mar 21st, 2011

Read the session log file, and also do check weather your target table is generated or not because if you are getting the result as 'now rows selected' then this might be one of the reason. You need to generate target table in designer itself.

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

Hi,Kamal1.check the preview data option in your source in mapping if the data comes to your srce then go for second stepif the data is not previewed check the source DSN2.check username of your sourc...

Answer Question  Select Best Answer