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

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

Design mapping to load the first record from a flat file into Table A, the Last record from a flat file into Table B, and remaining record into Table C

Nagendra

• Nov 5th, 2015

Append Seq Gen after SQ, add sorter, make it desc based on Sequence generated and use a variable to make first row as 0 then by using router route SEQGEN = 1 to A (First Row), Variable =0 to B (Last Row) and rest to C

sum

• Oct 8th, 2015

Use aggregator to take count of rows; then again join this aggregator to source pipeline using dummy columns. Now add one sequence generator and add next_val as srnum from it to each source columns...

Answer Question  Select Best Answer

How to find out duplicate records using aggregator. Pls explain with example. What is the need for placing joiner after aggregator. I just tried like the following:Count the records and group by all the columns. if the count=1 then it will be a valid record. what to do if the count >2.means file contains duplicate records.Why we need to use joiner after aggregator?

VISHNU VARDHAN

• Nov 17th, 2015

Use HAVING Condition in SELECT clause, You can write code like below to test, if it is greater than one then it is duplicate otherwise Unique.

Code
 

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 7th, 2012

Hi, Its similar to the SQL query, SELECT * FROM ,,.... FROM TABLE_NAME GROUP BY ,,..... HAVING COUNT(*)=1 Similarly in Informatica Aggregator transformation, select group by for all the columns and...

Answer Question  Select Best Answer

How and for what purposes we use look up transformation in Sales or Banking Project?

Raju Gupta

• Nov 25th, 2015

Look up is basically used for searching something. In case of banking project, consider a case where you have the customers id in one file and its salary stored in some other file. Now if you want to ...

Answer Question  Select Best Answer

What is the difference between SQL Override and Lookup Override

VENKATM

• Jan 2nd, 2016

You cannot use directly Union in Lookup Override. You can use in SQL Override. No join conditions in SQL Override. Join condition is compulsory in lookup.

dbseeker

 Profile Answers by dbseeker Questions by dbseeker

• Dec 20th, 2015

Can we have a different opinion on the 4th point? "Lookup override gives only one record even though there..." A lookup can return more than one record. We could handle this using the lookup property ...

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

How to load only the first and last record of a flat file into the target?

kishor Baindoor

• Jan 23rd, 2016

Connect source to two aggregator and then union it. In aggregator, if we donot check any column for aggregation then it will return last record by default. We can change this property in 2nd aggregator to return first record. When we union it we will get first and last record.

Raghav

• Apr 4th, 2015

Using rank and expression transformation.
More details at below link
http://www.raghavatal.com/2015/04/04/how-to-load-only-the-first-and-last-row-from-a-flat-file-to-a-target-file/

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

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

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

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

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

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

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

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

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

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

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