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

Why we use joiner transformation to update records in a flatfiles?

Sanket Kamble

• Oct 15th, 2020

Flat file cannot be updated but it is always overwritten

Answer Question  Select Best Answer

Static cache Dynamic cache U can not insert or update the cacheU can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations.The informatic server inserts rows into...

vp

• Mar 6th, 2006

lets say for example your lookup table is your target table. So when you create the Lookup selecting the dynamic cache what It does is it will lookup values and if there is no match it will insert th...

Answer Question  Select Best Answer

When the informatica server runs in the ASCII data movement mode it sorts session data using Binary sortorder.If U configure the seeion to use a binary sort order,the informatica server caluculates the binary value of each string and returns the specified number of rows with the higest binary values for the string.

phani

• Dec 9th, 2005

When Informatica Server runs in UNICODE data movement mode ,then it uses the sort order  configured in session properties.

Answer Question  Select Best Answer

The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group. For example, if you create a Rank transformation that ranks the top 5 salespersons for each quarter, the rank index numbers the salespeople from 1 to 5:

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 12th, 2006

Based on which port you want generate Rank is known as rank port, the generated values are known as rank index.Cheers,Sithu

Answer Question  Select Best Answer

Join data originating from same source data base. Filter records when the informatica server reads source data. Specify an outer join rather than the default inner join specify sorted records. Select only distinct values from the source. Creating custom query to issue a special SELECT statement for the informatica server to read source data.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 24th, 2006

Join data originating from the same source database. You can join two or more tables with primary-foreign key relationships by linking the sources to one Source Qualifier. Filter records when the Info...

Answer Question  Select Best Answer

U specify the target loadorder based on source qualifiers in a maping.If u have the multiple source qualifiers connected to the multiple targets,U can designatethe order in which informatica server loads data into the targets.

saritha

• Mar 1st, 2006

A target load order group is the collection of source qualifiers, transformations, and targets linked together in a mapping.

Answer Question  Select Best Answer

Simple Pass through maping : Loads a static fact or dimension table by inserting all rows. Use this mapping when you want to drop all existing data from your table before loading new data. Slowly Growing target : Loads a slowly growing fact or dimension table by inserting new rows. Use this mapping to load new data when existing data does not require updates.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

1. Simple Pass through2. Slowly Growing TargetCheers,Sithu

Answer Question  Select Best Answer

Type2 Dimension/Version Data Maping: In this maping the updated dimension in the source will gets inserted in target along with a new version number.And newly added dimension in source will inserted into target with a primary key. Type2 Dimension/Flag current Maping: This maping is also used for slowly changing dimensions.In addition it creates a flag value for changed or new dimension. Flag indiactes...

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 4th, 2006

Type21. Version number2. Flag3.DateCheers,Sithu

Answer Question  Select Best Answer

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

khadarbasha

 Profile Answers by khadarbasha Questions by khadarbasha

• Sep 30th, 2005

Performance can be improved by processing data in parallel in a single session by creating multiple partitions of the pipeline.Informatica server can achieve high performance by partitioning the pipleline and performing the extract , transformation, and load for each partition in parallel. 

Answer Question  Select Best Answer

For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection.Informatica server reads multiple partitions of a single source concurently.Similarly for loading also informatica server creates multiple connections to the target and loads partitions of data concurently. For XML and file sources,informatica...

durga

• Feb 13th, 2006

Fine explanation

Answer Question  Select Best Answer