Inner equi join.

Aaradhya

• Nov 10th, 2016

The Joiner transformation supports the following join types, which you set in the Properties tab: Normal (Default) Master Outer Detail Outer Full Outer Default join is Normal Join/Inner Join/Equi-Joi...

Vikas Dhakne

• Aug 8th, 2016

Source Qualifier transformation supports following types of joins:
1.Normal/Equi join
2.Left Outer Join
3.Right Outer Join

Answer Question  Select Best Answer

manoj_behera82

 Profile Answers by manoj_behera82 Questions by manoj_behera82

• Nov 9th, 2009

Basically source qualifier is a representation of the records that Informatica server reads when it runs the session. It is associated with a source can be a table or flat file as well. It is capable ...

divakar

• Nov 5th, 2007

A Source Qualifier transformation is the starting point in the mapping where in we are bringing the incoming data or the source data is extracted? from this? transformation after connecting to the?...

Answer Question  Select Best Answer

Naveen

• Nov 8th, 2012

Set source file type as INDIRECT

Amit Gaikwad

• Jul 26th, 2012

Step 1: Transfer all the 5 files on to your UNIX box or server from where you will fetch those 5 files Step 2: open notepad and type the 5 files name .ex:- a.csv ...

Answer Question  Select Best Answer

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

Top-Down approach means first create the datawarehouse for entire organization then divide it into for each specific subject are called datamartsBottom-Up approach means first create the data marts then by combining all data marts create the datawarehouse

samirdesai999

 Profile Answers by samirdesai999 Questions by samirdesai999

• Jun 13th, 2009

Top Down-------------To build an mammoth enterprise data warehouse iteratively considering all enterprise needs and then feed individual departmental data marts.Bottom Up------------To build ...

Answer Question  Select Best Answer

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

If both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.

vikota

 Profile Answers by vikota Questions by vikota

• Apr 12th, 2011

If both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifierif the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table

Answer Question  Select Best Answer

Pawan Singh

• Jun 15th, 2013

This will add that value into previous one

MAHESH MANAM

• Aug 16th, 2012

We can but the results may change what you are expecting in output

Answer Question  Select Best Answer

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?

pasupula.naidu

 Profile Answers by pasupula.naidu Questions by pasupula.naidu

• Dec 31st, 2010

For mapping parameters create a notepad file like this way, Sysntax:------------- [foldername.WF:workflow_name.ST:session_name] $$para_name=valuefor session parameters,sysnatx:-----------[...

hundwanipankaj

 Profile Answers by hundwanipankaj Questions by hundwanipankaj

• Apr 5th, 2010

Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. Power center is used for corporate enterprise data warehouse and power mart is...

Answer Question  Select Best Answer

venkat

• Dec 14th, 2011

In the look up properties whenever you check the dynamic lookup cache is enable, in lookup table new column is added automatically that is newlooup port. If the new lookup port is 0 then there is no change. If it is 1 insert and if it is 2 update.

srikanth

• Nov 18th, 2011

How to get total as new row and sum as 10.000

Code
 

Answer Question  Select Best Answer

What are the caches available in Joiner transformation?What is stored in Joiner cache(data cache) and Index cache?

Rashmirekha

 Profile Answers by Rashmirekha Questions by Rashmirekha

• Sep 2nd, 2009

For Unsorted Input joiner transformation, i) Data cache stores all master rows in the join condition with unque index keys ii) Index cache stores all master rows.For Sorted Input with Different ...

raam.pt

 Profile Answers by raam.pt Questions by raam.pt

• Aug 18th, 2009

Caches in JTR are 2.
1) Data Cache
2) Index Cache
1) Data Cache: It stores master source rows OS source table as configured in join condition.
2) Index Cache: It stores index values for master.

Answer Question  Select Best Answer

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

NO. We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.

CeeJay

• May 30th, 2013

No. It cannot be used in different mappings as when it is saved in the repository, it is saved for a particular mapping. And at global level we have mapping parameters only and not variables which cannot be changed.

Tapas

• Oct 6th, 2007

The scope of a mapping variable is the mapping in which it is defined. A variable Var1 defined in mapping Map1 can only be used in Map1. You cannot use it in another mapping say Map2.

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

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Query hints are used in RDBS concept, when you write SQLs in pervious days developer use give hint points while writing the query for DB engine, they are called rule based DB, now the rule based DB is fading out in the market, these days youwill find all new DBs as cost based

hemachandra

 Profile Answers by hemachandra Questions by hemachandra

• Dec 26th, 2007

Aggregate awareness is the method in Business Objects while creating measures in the universe, it is process where you define the aggregation strategy which you wanted BO to follow, useful mostly for Drill downs based on different dimentions

Answer Question  Select Best Answer

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 9th, 2008

Select business_key,max(version) from tablename group by business_key

ketannp

 Profile Answers by ketannp Questions by ketannp

• Feb 9th, 2008

Select Acct.*,Rank() Over ( partition by ch_key_id order by version desc) as Rankfrom Acctwhere Rank()=1

Answer Question  Select Best Answer

pawan Singh

• Jun 15th, 2013

TWS( Tivoli scheduler)

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 8th, 2010

Yes we can do by using this by third party scheduler by unix script some of the third prty schedules are1.autosys2.control-m3.cron in unix4.pcon scheduler

Answer Question  Select Best Answer

Rupesh Lokhande

• Oct 4th, 2018

1. SQL Override is to limit the number of incoming rows entering the mapping pipeline - Lookup Override is to limit the number of lookup rows to avoid the whole table scan by saving the lookup time ...

sarada

• Nov 28th, 2013

using source qualifier u can extract the data from sources,in over ride u can write the queries to run in the data base,where as in sql t/f u can write and run the queries in database and get the res...

Answer Question  Select Best Answer

rajesh

• Jul 14th, 2011

Using look up we can perform following 1.=,2.,4.=,6.!= also
But joiner 1.=,2.master outer,3.detailed outer,4.full outer

krishna

• Jul 12th, 2011

Lookup Transformation will perform Non_Equi Joins

Answer Question  Select Best 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

samirdesai999

 Profile Answers by samirdesai999 Questions by samirdesai999

• Jun 13th, 2009

Use following expression in update strategy transformation.iif ( condition 1 , DD_INSERT,  condition 2 , DD_UPDATE,  condition 3 , DD_DELETE,  DD_REJECT -- for default)and set session property as data driven, You can cross check these conditions values during session debug runs.

prade

 Profile Answers by prade Questions by prade

• Jun 26th, 2008

In general DWH scenario, we create TABLE_REJECT or FILE_REJECT to keep a check of the rejected records. For all the updates happening we keep timestamp or some other flag in the database.Before t...

Answer Question  Select Best Answer

Milind Jadhav

• Mar 21st, 2015

Informatica follow input variable n output process.thus you can make some calculations in variable port n copy them to the output port to achieve some purpose mostly used in expression tf

Kameshwara

• Aug 8th, 2013

variable ports are used in transformations like Expression/Aggregator where you can hold a value of incoming data. This can be helpful when you want to check if incoming column value is same or a cha...

Answer Question  Select Best Answer