The data movement mode depends on whether Informatica Server should process single byte or multi-byte character data. This mode selection can affect the enforcement of code page relationships and code page validation in the Informatica Client and Server.a) Unicode - IS allows 2 bytes for each character and uses additional byte for each non-ascii character (such as Japanese characters)b) ASCII - IS...

Read Best Answer

Editorial / Best Answer

Answered by: purushotham

• Aug 9th, 2005

---

the two types of modes are: 
1) Normal Mode in which for every record a separate DML stmt will be prepared and executed 
 
Bulk Mode in which for multiple records DML stmt will be preapred and executed thus improves performance.

amolrenose

 Profile Answers by amolrenose Questions by amolrenose

• Sep 18th, 2011

Data Movement Modes

1. ASCII mode :- Single byte of data is processed.
2. UNICODE mode :- Two bytes of data is processed.

Data Loading Modes

1. Normal Mode :- Commit is executed after 10000 records (default).
2. Bulk Mode :- Commit is executed after all records have been loaded.

sivakp

 Profile Answers by sivakp Questions by sivakp

• Mar 13th, 2011

1. ASCII mode2. UNICODE mode

Improve Answer

Read Best Answer

Editorial / Best Answer

Rajsuni  

 Profile Answers by Rajsuni Questions by Rajsuni

• Member Since Apr-2011 | Apr 1st, 2011

---

 Informatica Architecture :
            
   client tools-
                  Repositoy Manager->  Pc Designer->    WFManager->           WFMonitor       
                            |                               |                          |                                |
              (creat,mdify,del-folders,    (src&Tar def,         (create tasks             (display
              privilages& access RS)     mapings,maPlets)connect to work flow) reult/output)
   ---------------------

   Powercenter tools--
                   PC service   <--------------------->Repository Database
                          |
                          |
         <-------> PC Server<---->

here: Pc-PowerCenter.

venkat m

• Sep 20th, 2011

Informatica Architecture : client tools- Repositoy Manager-> Pc Designer-> WFManager-> WFMonitor | ...

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 15th, 2011

When we install the informatica powercenter, the following components gets ionstalled 1) powercenter clients 2) Integration service 3) powercenter Repository service 4) powercenter Repository 5) power...

Improve Answer

Rajarao marisa

• May 31st, 2012

Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...

srinuraj

 Profile Answers by srinuraj Questions by srinuraj

• May 31st, 2010

You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...

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 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

Joe

• Feb 7th, 2013

ECHO OFF This automates the informatica workflow run using pmcmd ECHO c:informaticaserverinpmcmd startworkflow -u username -p password -s server:host -f Folder -wait MYWORKFLOW

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 11th, 2008

C:-->Program Files-->Informatica PowerCenter 7.1.3-->Server-->bin-->pmcmd.exe

Answer Question  Select Best Answer

Chinna

• May 20th, 2013

Using Sorter Transformation it will delete duplicate records and using Expression Transformation... "c S->SQ->EXP->Router->TR.... Exp Logic=V_Prod_id=Prod_id V_Dup_...

Madhuri

• Jun 22nd, 2012

Use sorter transformation after SQ and check the distinct check box of sorter.finally connect to the tgt.

Answer Question  Select Best Answer

How to format phone number 9999999999 into (999)999-9999 in informatica

Vids

• Aug 13th, 2013

It can be achieved using the IDQ tool where u can set the standard format . EVen I am not sure how exactly

sreenu

• Dec 4th, 2011

Using the CONCAT (||) operator and SUBSTR function in the expression transformation.

Answer Question  Select Best Answer

What is the difference between STOP and ABORT options in Workflow Monitor?

Satish

• Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Sudha Rani

• Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Answer Question  Select Best Answer

What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.

Surbhit

• Apr 1st, 2014

Use an aggregator and do no group by any key

Ankit Kansal

• Feb 15th, 2014

Easy way of achieving the functionality is with Unix commands however if you want to achieve it using Informatica only then Then just before dumping your data to your target use aggregator count() f...

Answer Question  Select Best Answer

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

Yes, We can!

Open the folder where the reusable transformation is existing.

Then open mapping designer then drag the reusable transformation to mapping designer area. Now hold the Ctrl key and drop it.

Now you have non reusable version of your reusable transformation.

Thanks

Bibhu

• Jul 4th, 2014

Yes, we can. It can be done in the transformation developer.

Answer Question  Select Best Answer

Gayathri

• Jul 21st, 2014

Go to Session Properties->Config.Object, Make Stop on Error as 0.
This will not fail the session if there is error in 1 record. This will load all error free records.

Dinesh

• Jul 21st, 2014

If the source is FF, then use skip first 299 rows and then start loading.

If the source is relational then u row number.

Answer Question  Select Best Answer

Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee Name from Employee table based on the Employee IDPerform Calculation.Update slowly changing dimension tables - We can use unconnected lookup transformation to determine whether the records already exist...

Read Best Answer

Editorial / Best Answer

Answered by: prodyot Sarkar

• Jul 31st, 2007

---

The following reasons for using lookups.....

1)We use Lookup transformations that query the largest amounts of data to improve overall performance. By doing that we can reduce the number of lookups on the same table.

2)If a mapping contains Lookup transformations, we will enable lookup caching if this option is not enabled .
We will use a persistent cache to improve performance of the lookup whenever possible.
We will explore the possibility of using concurrent caches to improve session performance.
We will use the Lookup SQL Override option to add a WHERE clause to the default SQL statement if it is not defined
We will add ORDER BY clause in lookup SQL statement if there is no order by defined.
We will use SQL override to suppress the default ORDER BY statement and enter an override ORDER BY with fewer columns. Indexing the Lookup Table
We can improve performance for the following types of lookups:
For cached lookups, we will index the lookup table using the columns in the lookup ORDER BY statement.
For Un-cached lookups, we will Index the lookup table using the columns in the lookup where condition.

3)In some cases we use lookup instead of Joiner as lookup is faster than joiner in some cases when lookup contains the master data only.

4)This lookup helps in terms of performance tuning of the mappings also.

Satya

• Aug 9th, 2014

Use lookup transformation in a mapping to
--get related values
--perform complex calculation
--Handle slowly changing dimension.

gazulas

 Profile Answers by gazulas Questions by gazulas

• Apr 22nd, 2009

Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions,? so in middle of the mapping there is a requirement to get the data from some? x t...

Improve Answer

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Staging area may be required if you have any of the following scenarios: Delta Loading: Your data is read incrementally from the source and you need an intermediate storage where incremental set of y...

MAHESH MANAM

• Aug 16th, 2012

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

Answer Question  Select Best Answer

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

Answer Question  Select Best Answer

how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisalthanksvenu

milind

• Aug 6th, 2015

Yes dummy column will work
other way is to use mapping variable :)

ashish

• Sep 27th, 2014

You can create a dummy port in each source and assign 1 to both port and drag the both sources in joiner tr and give join condition on dummy port, After that you can use filter condition on your location

Answer Question  Select Best Answer

Suppose I have one source which is linked into 3 targets.When the workflow runs for the first time only the first target should be populated and the rest two(second and last) should not be populated.When the workflow runs for the second time only the second target should be populated and the rest two(first and last) should not be populated.When the workflow runs for the third time only the third target...

sum

• Oct 8th, 2015

Define one variable $$CNT in mapping and assign its initial value as 1 in parameter file Take an expression and do below coding count =$$CNT INC_COUNT=$$CNT+1 O_INC_CNT=SETVARIABLE($$CNT,INC_COUNT) Ad...

Rakesh

• Feb 9th, 2015

your above logic is perfect..but instead resting the variable at workflow level you can add these condition in first router group => MOD(o_Flag,3) = 1 2nd router group =>MOD(o_Flag,3) = 2 3rd router g...

Answer Question  Select Best Answer

Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?

Read Best Answer

Editorial / Best Answer

ghola  

 Profile Answers by ghola Questions by ghola

• Member Since Jul-2008 | Aug 15th, 2008

---

The joiner transformation compares each row of the master source against the detail source. Hence, fewer number of rows in master means fewer iterations of join comparison.

Secondly It is easier to cache the table with fewer number of rows.

Hence, using the table having the fewer number of rows as a master improves the performance.

Raju R

• Oct 27th, 2015

@ponnana: The performance of the joiner depends on the rows and not on the columns. Also you take up the condition which consists n number of columns. Based on the condition the rows are obtained. So We need not worry about the columns.

Rashmi

• Oct 18th, 2015

The join is happening based on some condition. Therefore match process depends on the condition columns only and not how many columns are present in total. The table you drag into joiner first is considered as Master.

Improve 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

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