What are the different types of partitons in Informatica?

• Oct 21st, 2011

Informatica partitions are used to improve the performance of power center through parallel data processing. The different types of informatica partitions are database partition, pass-through partitio...

Answer Question  Select Best Answer

In session level, What is the difference between Informatica 7 and 8

sridkaretl

 Profile Answers by sridkaretl Questions by sridkaretl

• Oct 21st, 2011

The main difference is

1) Architecture difference
2) Java trasformation has been introduced
3)user defined functions
4)dynamic configuration of cache and partitioning.

Answer Question  Select Best Answer

lpmca

 Profile Answers by lpmca Questions by lpmca

• Mar 22nd, 2011

DTM is Data Transformation Manager.  Integration Services are used to move data from source to target based on workflow and mapping metadata stored in the repository.Integration services will sta...

Answer Question  Select Best Answer

What is Load Manager? What is the use of it in Informatica. In which situations would you use it in realtime.

saithirumal

 Profile Answers by saithirumal Questions by saithirumal

• Mar 26th, 2011

if i run session or workflow that start an DTM process.the main purpose of Load Manager or Balance Load Manager is to find out which node is ideal among the nodes then assign the session task to that ...

Answer Question  Select Best Answer

hi, hi can anybody answer my query... that is i had a source table containing for eg;D1,D2,D3,D4,D5 one by one that means in a each column contains single source i.e., D1 in 1st col,D2 in 2nd col so on now i want in my target like D1-D2 in one col, D1-D2_D3 in other col,D2_D3-D4 in other col and D3-D4-D5 in other col plz send as soon as possible.......... thanx in advance

Ashish

• Jul 23rd, 2011

Use expression transformation to get the desired output

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

One can pass the input through the expression, where the variable/output ports can be configured to pass the combined value by using the CONCATENATION function of informatica.

Answer Question  Select Best Answer

Hi everyone ,Can u explain in detail what is a join index,with example.And what is its importance in teradata.

Read Best Answer

Editorial / Best Answer

rin23  

 Profile Answers by rin23 Questions by rin23

• Member Since May-2011 | May 12th, 2011

---

A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the way that it is used automatically by the database system to improve the performance of a query. Join indexes use the "classic" space-time trade off trading disk space for storage of the join index to get improved performance for queries. Unlike many other materialized view implementations, Teradata join indexes are updated immediately and automatically when changes are made to the base tables. There is never a concern that you might be using stale data when the system chooses to use a join index in the query plan. Also, Teradata uses its sophisticated coverage testing algorithm to minimize the cost associated with join index maintenance.?

rin23

 Profile Answers by rin23 Questions by rin23

• May 12th, 2011

A join Index is a cross between a view and an index. It is like a view in that it is created using a query to specify the structure, composition and source of the contents. It is like an index in the ...

Improve Answer

Can any body suggest the practical example where mapping parameter or variable is used, Please suggest the same for session parameter and variable..?

Rajeev Das

• Sep 2nd, 2011

Mapping Parameter is a constant value which remains same throughout the entire session, whereas Mapping variable value keeps changing as many times we run the session. Senario (mapping parameter), ...

Answer Question  Select Best Answer

One source is flat file and other source is oracle, then how do you do the mapping?

sppavankumar

 Profile Answers by sppavankumar Questions by sppavankumar

• Jul 18th, 2011

There are two possible ways of doing it: 1) Both used in a single mapping with single pipeline(Joiner can be used, in order to join both the source in the mapping) 2) Use two different pipelines in a ...

xitij7185

 Profile Answers by xitij7185 Questions by xitij7185

• Jun 13th, 2011

With joiner transformation .

Answer Question  Select Best Answer

please explain working with transactions in joiner transformations. What conditions are set. And any scenarios where it is used.

Sreenu

• Nov 19th, 2011

Please get this information from the Informatica help file( no one can give better than in help)

Let us if you are looking for the answer on any specific requirement

Answer Question  Select Best Answer

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