satyakamal

 Profile Answers by satyakamal Questions by satyakamal

• Mar 4th, 2007

22 is the exact number

manju

• Jan 31st, 2007

I checked out its 22 transformation in informatica 7.1.1...pls note dis

Answer Question  Select Best Answer

jithendra

• Mar 6th, 2007

Hi,you can have source left outer joined to target table using the key columns to verify if an incoming row already exists in the target.e.g. consider A as source & B as target. And the key column...

Pradeep

• Mar 3rd, 2007

You could have a SQL override in the Source Qualifier with something like: select * from source_table where not exisits in target_table

Answer Question  Select Best Answer

kmahidar

 Profile Answers by kmahidar Questions by kmahidar

• Jan 30th, 2012

Create a variable port : v_cume_sal=v_cume_sal+amt
output port : o_cume_sal=v_cume_sal

kmahidar

 Profile Answers by kmahidar Questions by kmahidar

• Jan 30th, 2012

In Expression t/r
Create one variable Port v_cum_sal=v_cuma_sal+sal
output port o_cum_sal=v_cum_sal

Answer Question  Select Best Answer

avneeshrathor

 Profile Answers by avneeshrathor Questions by avneeshrathor

• Nov 3rd, 2009

Use target update override and write down your SQL update statement there. It will not require any keys. Before that use whatever to identify which row qualifies for an update and which not.

vivek1708

 Profile Answers by vivek1708 Questions by vivek1708

• Jul 30th, 2008

It is true - that it wont work without the keys - dynamic look up and update but if the combination of the columns used for look up always returns a unique value - the update shall still work, even if the keys are not defined.

Answer Question  Select Best Answer

Hi,I am just wondering if there is a direct way to load Excel file into database using Informatica without having to convert Excel to .CSV or XML format. Because we may have to load data from different Excel worksheets.Thanks in AdvanceSrini

Sreedhar Lokaray

• Jul 11th, 2014

We have a separate client tool in Informatica called B2BDT. Earlier it was called as Complex Data Exchange. This tool is used to read data from different sheets of an xls. Not only xls it can be used to read data from pdf, word docs etc.

Manohara Devara

• Jul 3rd, 2012

Hi
Go to source and create required ports and send to Expression..there we need to converted the delimiter file or Comma separate file by using the ltrime and rtrime values...and send to target ....

Answer Question  Select Best Answer

in mapping level we have update strategy in that we have DD-update and at session level we have DD_insert when we run mapping what will happen is it inserted or updated?

Amritendra kumar

 Profile Answers by Amritendra kumar Questions by Amritendra kumar

• Feb 29th, 2008

As per my openion it will insert only because it give preference to session

chandrarekha

 Profile Answers by chandrarekha Questions by chandrarekha

• Feb 5th, 2008

It performs insert operation,because session overwrites the mapping level properties

Answer Question  Select Best Answer

What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?

anupama2000

 Profile Answers by anupama2000 Questions by anupama2000

• May 26th, 2008

The need for ODS is to clean the data coming from hetrogenous sources. To maintain data quality for better warehouse which provides good reporting.

pal.amol

 Profile Answers by pal.amol Questions by pal.amol

• Mar 1st, 2008

The Data cleaning tool name which is been widely used unliked Informatica (ETL tool ) name is FirstLogic.

Answer Question  Select Best Answer

What is the purpose of using UNIX commands in informatica?Which UNIX commands are generally used with informatica?

nisithm

 Profile Answers by nisithm Questions by nisithm

• Dec 3rd, 2009

PMCMD to run your workflow

gaurav2485

 Profile Answers by gaurav2485 Questions by gaurav2485

• Jan 8th, 2009

We are using Unix in Workflow manager mainly for locating the Source / Target (Flat file) or writing script (if Server is installed in Linux)

Answer Question  Select Best Answer

gaurav2485

 Profile Answers by gaurav2485 Questions by gaurav2485

• Jan 8th, 2009

Suppose we have choose 10000 source to be commitSource based Commitment is it will read 10000 rows and pass through many transformation (active and passive) so upto what out of 10000 rows it reaches t...

av_ashish

 Profile Answers by av_ashish Questions by av_ashish

• Oct 17th, 2008

These are the 3 types of commits possible in INFATarget-based commit. The PowerCenter Server commits data based on the number of target rows and the key constraints on the target table. The commit poi...

Answer Question  Select Best Answer

How three column in one table concatenated in Informatica?When i am giving SAL || COMM || DEPTNO in exp it's failed to read during testing.By giving (CONCAT(CONCAT(SAL,COMM),DEPTNO)) i am also getting error during testing.

ramakrishna82

 Profile Answers by ramakrishna82 Questions by ramakrishna82

• Aug 12th, 2009

emp_first_name |' '|emp_middle_name|' '|emp_last_name

raj_infadev

 Profile Answers by raj_infadev Questions by raj_infadev

• Oct 13th, 2008

In Informatica its better to use the symbols to make the operation faster cause Power Center Server can understand the symbols more easily than the function names....For Example: Concatenation operati...

Answer Question  Select Best Answer

Why sequence generator is not directly connected to joiner transformation?

manoj_pathak

 Profile Answers by manoj_pathak Questions by manoj_pathak

• Sep 30th, 2009

Remember Joiner tx can accept input from only 2 pipelines.Now only following 2 scenerios possible to have both joiner and Seq Gen tx:1)2 input pipelines are already connected and then we want to conne...

itisanimesh

 Profile Answers by itisanimesh Questions by itisanimesh

• Aug 6th, 2009

In Addition to previous answerSequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key values or cycle through a sequential range of numbers...

Answer Question  Select Best Answer

How do you handle error logic in Informatica? What are the transformations that you used while handling errors? How did you reload those error records in target?

Umesh

• May 14th, 2012

So we create 2 variable for every field on which we have to do error logging. 1 variable will check the condition for error (i.e. check for isnull or check for datatype) and assign NULL if it does not...

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 11th, 2010

It is one of the most common concept which is being implement in alomost all DW projects. A very simple way of handing error and with their approprite messages is:Concat all the columns with a delimet...

Answer Question  Select Best Answer

If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 4th, 2010

With Incremental Aggregation.

reddykuruganti

 Profile Answers by reddykuruganti Questions by reddykuruganti

• Jun 7th, 2010

Simply you can restart the session, by selecting truncate table option in the session properties.

Answer Question  Select Best Answer

How to delete first 3 rows & last 3 rows in target table in Informatica?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

1. SQ 2. Expression --> Connect the expression with the Sequence Generator 3. Aggregator with one column(key column if any) Out_Count=count(*) Dummy_count=1 3. Expressio...

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Sep 3rd, 2012

Hi,

We can use a sql in the sql override:

select count(1) from
(select * from where rownum

Answer Question  Select Best Answer

sriinivas kasiboina

• Feb 15th, 2012

SCD Type 3 is used when it is necessary for datawarehouse to keep track of historical changes and when such changes will only for finite number of times.

sriram

• Sep 27th, 2011

Scd type3 is used for loading the current & most previous data into target

Answer Question  Select Best Answer

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

Answer Question  Select Best Answer

How to format phone number 9999999999 into (999)999-9999 in informatica

Vids

• Aug 13th, 2013

It can be achieved using the IDQ tool where u can set the standard format . EVen I am not sure how exactly

sreenu

• Dec 4th, 2011

Using the CONCAT (||) operator and SUBSTR function in the expression transformation.

Answer Question  Select Best Answer

Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?

ashwin

• Mar 22nd, 2017

SRC-->SQ--> JNR-->EXP-->RTR-->TGT(Insert for both new and updated records) SRC(TGT)-->SQ--> -->TGT(Update The entire implementation will be same as that using a l...

ashwin

• Mar 22nd, 2017

The entire implementation will be same as that using a lookup. The only thing we need to replace the Lookup transformation with a Joiner transformation. In the Joiner transformation the Source table w...

Answer Question  Select Best Answer

Import flat file from the source (with nulls) it should display without null values in the target

laxmi

• Nov 10th, 2014

We can use validate record component with is_null() function.

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

After importing the flatfile, after the source qualifier use an expresssion transformation. In expression transformation use the condition IIF(column=NULL,0,Column)

(you can use either 0 or any other value u like..)

Answer Question  Select Best Answer

I have 1 crore record in my table and I have to load 25 Lakh in 1st target, 25L in 2nd target and 25L in 3rd target? How to load 1 crore records into 3 different targets having 25 L records in each?

vinit

• Jun 22nd, 2016

(SQ + Seq Gen) ---> Exp ---> sorter ----> router (having four groups for seq gen port) ---> four targets

Venkat

• Jun 13th, 2016

Pass Source qualifier to Expression Expression Condition Variable port(V_COUNT) - IIF(V_COUNT < = 75000,1,V_COUNT+1) O/P (Port segregation) - decode(true, V_COUNT < = 25000,1 ...

Answer Question  Select Best Answer