What is a look up function? What is default transformation for the look up function?

pranusha

• Nov 8th, 2012

The lookup function is used to compare source data with another table based on a certain condition. If the condition is true than the lookup function returns columns that satisfy condition.
The default transformation for lookup function is lookup transformation.

Answer Question  Select Best Answer

How to write stored procedure,which take the sequence name as input and dynamically generates a nextval from that sequence

Ashish

• Jul 30th, 2014

"sql Create or Replace Procedure P_Get_Value( seqnm IN Varchar2) Is L_Var Varchar2(100); TYPE cur_typ IS REF CURSOR; c cur_typ; Begin OPEN c FOR SELECT || seqnm || ...

Answer Question  Select Best Answer

Sarita

• Oct 23rd, 2013

The errors faced are:

1)Duplicate data in target tables
2)Performance issues
3)File rejections due to error in header and trailer records
4)Logical errors

Answer Question  Select Best Answer

jaya

• May 15th, 2016

1. Lookup has become both active and passive in 9.6.
2. 9.6 has got the property to tackle db deadlock resalliance.

Answer Question  Select Best Answer

( cross platform integration) - I am new to informatica n SAP , i got assignment work on integration of informatica and SAP R/3 , i need to import data from SAP , i went to could of videos on YouTube provided by Informatica Support , they are saying you need to install RFC libraries that are available on SAP market place, RFC libraries are platform specific , i do have SAP system on Unix and informatica...

prashanth naik

• Jul 7th, 2015

You can do it by configuring the Application connection, the connection will generate the ABAP code which hits SAP R/3 system and does data extraction.

Answer Question  Select Best Answer

In SCD Type2 scenario, Informatica has no control on the DML operation.
How will we make sure that updates happen before Inserts in SCD Type2 dimension so that we can avoid the AK constraint error.

Abhilash tyagi

 Profile Answers by Abhilash tyagi Questions by Abhilash tyagi

• Jun 6th, 2015

You can try to change the name of the target instances. For example, let us consider we have 2 instances of targets CUST_D (insert) and CUST_D1 (update), try to change the name of insert instance to C...

Answer Question  Select Best Answer

How to generate a star pattern using Informatica depending on the number of rows in the input file

Suppose there are 7 rows in the source file (any type of data), the target should have 7 rows of stars in the following pattern:-

*
***
*****
*******
*********
***********
*************

SUM

• Oct 8th, 2015

V_star=iif( v_vount < = 1,*,rpad(v_star,vcount,*))
v_count=v_count+2
O_STAR=V_STAR

Answer Question  Select Best Answer

How to load 10000 records into dynamically created 100 files and to load 100 records in each?

Snehasis

• Sep 12th, 2015

This can be done using TC transformation. In an expression before the TC, keep a counter which increments for each row passed. When the counter reaches 100, reset the counter to 0. In the expression...

Answer Question  Select Best Answer

How to override LOOKUP in Informatica?
How to tune LOOKUP in informatica?

Niranjan

• Nov 5th, 2015

Use an SQL ovveride in properties. Query should contain only the required columns and required joins based on requirement. Grouping the Columns in the SQL Override yield better results.

Answer Question  Select Best Answer

Can we use more than one parameter file in a workfow? If yes, how? If No, Why?

ishan

• Nov 1st, 2015

Yes, we can. In case of concurrent execution of workflow. Go to workflow, properties, there is a option of concurrent execution. In case we enable it we have an option of running multiple instances of workflow using different parameter files.

Answer Question  Select Best Answer

Performance wise which is better connected or unconnected lookup transformation?

priya

• Jan 13th, 2016

Connected and unconnected lookup depends on scenarios and performance. If you are looking for a single value for look up and the value is like 1 in 1000 then you should go for unconnected lookup. Perf...

Answer Question  Select Best Answer

My source records have nulls. How to create dynamic file name?

SHYAM

• Mar 7th, 2016

Create a new field in EXP TRF NAD Hard Code the Value based upon the data in your source.

Example: IIF(ISNULL(COLA),FILENAME,VALUE).
This FILENAME will be given to the text TARGET where DATA which has nulls.

Similarly go for different scenarios.

Answer Question  Select Best Answer

How to convert date format 09-aug-79 to 08-09-1979? I am not able to convert it into 1979 in my case it gives me either 0079 or 2079.

Prasad

• Mar 10th, 2016

To_date(to_char(09-aug-79,dd/mm/yy),dd-mm-yyyy)

Answer Question  Select Best Answer

What is main difference between dynamic lkp and static lkp with example? Performance wise which one is better?

Prasad

• Mar 8th, 2016

Cache can change at run time in Dynamic cache LKP, Performance wise Static LKP is better

Answer Question  Select Best Answer

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

1) 5 fields are in the index cache and 3 are in the data cache.
2) 2 fields are in the index cache and 3 fields are in the data cache.

Anil

• Jun 22nd, 2016

According to Informatica regulations index cache built the cache for conditional ports and non-conditional ports are cached into data cache so answer is 2 in index and 3 in data cache

Answer Question  Select Best Answer

I am loading records from a source table to a CRM target table. I want to get the details of the manually inserted, updated, deleted records from the target table. Please explain in detail.

Nilesh Hajare

• Sep 22nd, 2016

You can check the user id column of CRM object.

Answer Question  Select Best Answer

I am not able to understand the different between PreSql in Source Qualifier and PreSQL in Target in Informatica. I read many other posts they told

pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".

So if all PRESQL run at same point...

Anurag

• Nov 27th, 2017

Pre-SQL in SQ is use to run the SQL in source database and similarly preS-QL in target for target DB.
This is useful when the source and target database are different .

Answer Question  Select Best Answer

How to create a session log as a parameter in informatica cloud?

sailaja

• Oct 23rd, 2017

At session level if we click on general option you will find session log file, session log folder. We can perameterise those. (ex: $session log file)

Answer Question  Select Best Answer

Assuming that the master pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation.then How many fields are in the index and data cache files?
options:
a. 5 fields are in index and 3 in data cache
b. 3 fields are in index and 2 in data cache
c. 2 fields are in index and 3 in data cache
d....

Prithu

• Aug 27th, 2018

The answer sld be C

Answer Question  Select Best Answer

Suppose in Informatica a source file has 1 column(CITY) and datas are Pune, Kol, Pune. Want to load CITY data to dynamically generated target file(means it will create 2 targets, named Pune and Kol and in Pune target, value will be Pune and in Kol target, value will be Kol) ?

Priyanka Kumari

• May 24th, 2018

use this flow: sorter (on city) -> Expression (compare the current and previous cityname and based on that create the FLAG in another Variable port.) -> Transaction Control (IIF FLAG = 1, TC_COMMIT_B...

Answer Question  Select Best Answer