What are few real time issues or problems while doing Informatica project. As a Informatica ETL developer, what will be the daily tasks or work.

sreenu

• Nov 19th, 2011

Actually it depends on the projects...

Anyway you will see the below issues in general

1. some specific characters are not loading as in the source
2. Data truncation happened on few fields
3. Frequent changes are coming from the user
4. Performance issues when loading huge data

Answer Question  Select Best Answer

Q. How can you minimize the cache size for a Joiner transformation?
(A) Make the smaller source the master source.
(B) Make the smaller source the detail source.
(C) Sort the master data prior to the Joiner transformation.
(D) Sort the detail data prior to the Joiner transformation.

Munavar

• Mar 21st, 2012

A.Make the smaller source the master source.

Answer Question  Select Best Answer

Gourav Mukhija

• Sep 7th, 2011

Flag are mostly use in Update Strategy Transformation. there are four flag which are manly used 1) INSERT (dd_insert or 0) 2) UPDATE (dd_update or 1) 3) DELETE (dd_delete or 2) 4) REJECT (dd_reject o...

Answer Question  Select Best Answer

Explain how the batch processing works in informatica ? When would it be useful in real-time projects ?

snigdha ojha

• Oct 12th, 2011

When we run multiple sessions in a single workflow sequentially that is called batch processing. This is useful when we create relational database for any company.

Answer Question  Select Best Answer

Through one session how we load half of data from flat file on 1st run of session and on 2nd run of the same session it load rest half of data to the same target ?

Ankur Mishra

• Apr 26th, 2012

Create two session which points to the same mapping and parameterise the source qualifier query in a way that it picks first half record for the first session run and second half for the second sessio...

Answer Question  Select Best Answer

Hi all

I have been ETL informatica Developer for last few years.I am good at SQL and Unix.I need some guidance for my career.I wanna learn BO or any other reporting tool along with ETL.I wanna learn anything more which could help my career .I just some guidance from all of you.Please help.

Thank You
Prithvi

Anil Borru

• May 28th, 2012

My suggestion is ETL tools having lot of demand in Market so better don't change path and try to learn Datastage or another ETL tools.

Answer Question  Select Best Answer

Vids

• Aug 13th, 2013

ETL automation scripts. Ideally , u can use the Informatica schedule to automate /schedule the workflow.

U can either do it using a Unix shell script . Use the PMCMD command , the workflow , folder details in the shell script. (U can check in the Informatica help for the pmcmd syntax)

Answer Question  Select Best Answer

I have 2 sources one is relational table with 7 ports
second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 3rd, 2012

Hi, I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on ...

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

How to solve pcsf_10342 when enabling integration service in Informatica 8.6.1 ?

Sudarshan

• May 2nd, 2012

Login to the admin console and delete the repository content and recreate it. Restart the integration service. It works!

Answer Question  Select Best Answer

How to explain sales project in interview.could u tell me modules or dim table with some column names and facts how to move data from dim to facts.and give me what logic u implement in that projects

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jan 3rd, 2013

For explaining your sales project: You can follow these points and cover them based on your actual project. 1. Name of the Project 2. Name of the Client 3. Brief Description of the Client 4. Brief ...

Answer Question  Select Best Answer

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