-
What is difference between source base and target base commit
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
- 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...
-
How three column in one table concatenated in Informatica?
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.
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...
-
Sequence Generator
Why sequence generator is not directly connected to joiner transformation?
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
- 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...
-
Error handling Logic
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
- 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...
-
Data Loading While Session Failed
If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?
reddykuruganti
- Jun 7th, 2010
Simply you can restart the session, by selecting truncate table option in the session properties.
-
Delete First 3 Rows & Last 3 Rows in Target Table
How to delete first 3 rows & last 3 rows in target table in Informatica?
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
- Sep 3rd, 2012
Hi,
We can use a sql in the sql override:
select count(1) from
(select * from where rownum -
-
Transaction control transformation to get flat file names
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
- 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
-
Informatica number formatting
How to format phone number 9999999999 into (999)999-9999 in informatica
-
In scd type2
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?
-
How to remove the null values in flat file ?
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
- 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..) -
Load 1 crore records into 3 different targets having 25 L records in each?
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?
-
Why use the lookup transformation ?
To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read. Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as net sales). Update...
vivek1708
- May 8th, 2008
Hi The ans to ur question is YesThere are 2 types of lookups: Dynamic and Normal (which you have termed as Static).To configure, just double click on the lookup transformation and go to properties tab...
binoop
- Mar 22nd, 2007
For maintaining the slowly changing diamensions
-
What are the Differences between Informatica Power Center versions 6.2 and 7.1, also between Versions 6.2 and 5.1?
Raja
- Feb 27th, 2007
Regarding transformations:In 7.1We use look up on flat filesthere is union transformation
-
What are the Repository types in Informatica PC 6.1 onwards.
superhero
- Dec 5th, 2008
Local---------->versioned,non-versionedglobal--------->versioned,non-versioned
adilshariff
- Jul 1st, 2008
There are two types1.GDR and LDR2.Versioned and NonVersionedWe can use them in combinations, meaningGDR [Versioned/Non Versioned[Default]]LDR [Versioned/Non Versioned[Default]
-
Can we update data into target without using update strategy transformation?
Baloo_nanduri
- Jul 25th, 2010
Yes, its possible using Update override option available for Targets in designer
Sumithav29
- Sep 3rd, 2009
We can update the target table, by using the update override in target definition. it will update based on non key columns.
-
My source is having 1000 rows. i have brought 300 records into my ODS. so next time i want to load the remaining records. so i need to load from 301 th record. when ever i start the work flow again it will load from the begining. how do we solve this problem. thanks in advance kiran
-
How can we call Stored Procedure in Work Flow Manager?
rajvinformatica
- Mar 28th, 2010
I have written as Stored Procedure to get all the Tables from a two Server Server1 and Server2 (parameterized Values) and load them in to two different tables internally through the S.PThis ...
sarita.harsh
- Mar 5th, 2009
Create a dummy mapping with dummy as source and target column. Then create a session corresponding to this mapping. In the session go to tab Mapping.Then select the source in task type. In connecti...
-
When do u use a unconnected lookup and connected lookup....what is the difference between dynamic and static lookup...y and when do v use these types of lookups ( ie...dynamic and static )
satya
- Mar 17th, 2016
Connected Lookup is nothing but it connects to source and target. It can receive multiple inputs returns multiple output.
Unconnected Lookup connects either source or target. It takes multiple inputs but returns single output.
Thank You
Satya
Ketaki Kulkarni
- Dec 7th, 2009
Apart from the answers above here is the difference between Static and Dynamic Cache.Static cache is created when the Lookup transformation is encountered for the first time. If this cache is set to b...
-
Informatica Interview Questions
Ans