In which situation do we use update strategy?

Anil

• Jun 22nd, 2016

If we want to perform 2 DML operations but same operations it is not better to use update tr. use property in session (treat source rows as) instead of creating update tr. If we want to perform 2 DML...

ankit

• May 4th, 2016

Can any one tell me in which scenario it is not advisable to use update strategy?

Answer Question  Select Best Answer

How to load top/last 3 record using parameter file in Informatica?

Anil

• Jun 22nd, 2016

Parameter files are meant to standardize business rules we can specify, from what column the data is to be extracted and loaded but I think it is not possible to load top/last 3 record by parameter file?

janardhanan

• Jun 12th, 2016

Using Rank Transformation

Answer Question  Select Best Answer

If 5 records are there in source, how will you make 10 in targets (double the number of records in source, duplicate source records)?

Anil

• Jun 22nd, 2016

We can do it by taking expression t/r and 2 instances of same target and connecting from same exp to 2 targets!

Anupam Kumar

• Apr 8th, 2016

Use Router. Create two group and just put TRUE in both

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

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

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

What is meant by informatica grid? what are the component of informatica grid?

Fabio Mendon?a

• Mar 31st, 2016

When I use a grid in a Workflow and my second session (S2) has distributed on 3 links .... Question: The process that run on link 1 (S1 , S2 , S3 , S4, S5) , get the same link until the end (S5) ?...

Pruthvi S

• Dec 21st, 2014

A grid is an alias assigned to a group of nodes that allows you to automate the distribution of workflows and sessions across nodes. When you use a grid, the Integration Service distributes workflow...

Answer Question  Select Best Answer

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

 Profile Answers by Ketaki Kulkarni Questions by 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...

Answer Question  Select Best Answer

pr

• Mar 10th, 2016

Joiner : > It support equiv Join only. > It may be we can perform outer join only. > Joiner is used to source only. > It may be only "=" operator used. > In joiner may be not present in lookup ov...

Nishikant Shekhar

 Profile Answers by Nishikant Shekhar Questions by Nishikant Shekhar

• Jul 22nd, 2009

Lookup transformation is a Passive transformation where as Joiner is Active Transformation.Lookup you can have both connected as well as unconected where as Joiner is always connected.Joiner is used t...

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

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

Thru informatica how we can load only last 100 records.

Prasad

• Mar 8th, 2016

SQ->exp->filter->target

In expression we need to calculate sequence number then filter records in filter transformation as column>=50 and column

Naveen

• Dec 11th, 2015

Use SQ --> EXP --> RANK --> TGT

In EXP initialize v_count=v_count+1
In Rank Txn, rank on v_count and select BOTTOM 100.

I think, this will work.

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

Sharmila

• Mar 5th, 2016

We can validate all mappings at a time which are in a single folder level in Repository. Steps to follow: In power center Designer: Goto Tools => Queries 1. Create "New" Query in Query browser 2. Q...

swaroopkanth

• Feb 8th, 2012

We can validate all the mappings in the repository at once. This is possible through the repository manager.

Answer Question  Select Best Answer

shambhu

• Feb 25th, 2016

1. SQ is used to represent the data from sources (relational, flat file) which Integration service can read
2. Normalizer is used as a source qualifier when we have Cobol source (Denormalized), which SQ can not read
3. Normalizer can be used for transposing columns into rows

RSUDHAKARREDDI

 Profile Answers by RSUDHAKARREDDI Questions by RSUDHAKARREDDI

• Jun 20th, 2011

Source qualifier transformation extract data from only files and rdbms.but normaliser transformation used to extract data from COBOL files.

Answer Question  Select Best Answer

I am new to Informatica and learning it, Can anybody please tell me how we receive source as flat file in informatica? From where we get this flat file?

yusuf

• Feb 20th, 2016

You create a one note in desktop and insert the data with delimiter as you require and save it . Go to source qualifier and import as flat file and import from desktop.

xyz

• Feb 19th, 2016

We need to create the Flat file or import the file if already exists. Source Analyser--> Create or Import file

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

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

How to join two tables when there is no matching colomns? What is the approch?

Ganesh

• Feb 2nd, 2016

We will create dummy port and data type is 1

Answer Question  Select Best Answer

How to tune the session,workflow for better perfomance,what are the things we consider for better performace?

Ruhi

• Feb 1st, 2016

Partitioning, line sequential buffer length, tracing level as terse, collect performance data as enabled, commit interval are some of the pointers for session level performance tuning.

Rajesh Kumar

• Sep 16th, 2014

Make sure the Sorted Inputs enabled for Joiner, Lookup and Aggregate transformations in workflow.
Use Dynamic cache for lookups whenever needed otherwise cache takes more spaces (instead of cache)

Answer Question  Select Best Answer