mani

• Sep 7th, 2011

Its n-1, so you need 9 transformations.

venkatesh

• Sep 7th, 2011

One joiner transformation

Answer Question  Select Best Answer

What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

Read Best Answer

Editorial / Best Answer

sarun5  

 Profile Answers by sarun5 Questions by sarun5

• Member Since Feb-2008 | Mar 13th, 2008

---

Guys I have got the answer for which I asked..here you go

This can be handled by using the file list in informatica. If we have 5 files in different locations on the server and we need to load in to single target table. In session properties we need to change the file type as Indirect.
(Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
When you select Indirect, the PowerCenter Server finds the file list then reads each listed file when it executes the session.)
am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type as Indirect.

Anurag

• Nov 27th, 2017

You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.

Ashok Gulagond

• Dec 16th, 2016

When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?

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

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 12th, 2011

In Star schema, the data in the dimensional table is denormalized where as data in the Snow flake schema, it is normalized

ananta.prasad

 Profile Answers by ananta.prasad Questions by ananta.prasad

• May 3rd, 2008

In any schema fact table is in normalized form . it has reference keys to reference dimensional tables. Hence it is normalized

Answer Question  Select Best Answer

Narendra

• Sep 10th, 2011

Union will give duplicate records also. Main reason is it is derived from custom transformation when union used with custom transformation at that time it works as active transformation. if any transformation have active functionality definitely that transformation is active.

Thanks
@Nandu

mani

• Sep 8th, 2011

Union returns the distinct values when you merge the result set from 2 different tables.so duplicates are not allowed, so it is active transformation

Answer Question  Select Best Answer

malla reddy pannala

• Jul 25th, 2011

staging area is just like parking area before we entering the dwh here we doing here collecting the data from various data bases like oracle,db2, teradata to a single data base any of them, remove dup...

noverino

 Profile Answers by noverino Questions by noverino

• Feb 23rd, 2007

Staging area is temporary area used by ETL to do "Transformation" process. It could be anything, namely database, flat file, memory (cache), complex file, etc. In ETL, there's minimal 3 area: Source, Staging, Target (DW/DM).

Answer Question  Select Best Answer

If I have a source as below:Employeed, FamilyId, Contribution1,A,100002,A,200003,A,100004,B,205,B,20________________________________And my desired target is as below:EmployeeId,Contribution(In Percent)1,25%2,50%3,25%4,50%5,50% ____________________________________________________________________________Explanation: The contribution field in target is the individual Employee's share in a family's contribution.Say...

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
 

Mohan Krishna Bellamkonda

• Sep 7th, 2017

Code
 

Answer Question  Select Best Answer

Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.

pradeeshkumar

 Profile Answers by pradeeshkumar Questions by pradeeshkumar

• Aug 19th, 2010

Router transformation can be said as an extension of filter transformation. Filter allows you to check for a single condition and rejects rows which does not meet the condition.But Router transformati...

YugandharS

 Profile Answers by YugandharS Questions by YugandharS

• Jun 17th, 2010

Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.

Answer Question  Select Best Answer

Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

sandeepbabu

• Apr 21st, 2014

Maplet is a resuable object,created with business rule using set of transformations and maplet is created with i/p maplet transformation and o/p tarnsformation. Maplet can be created without i/p maplet transformation.

It can be divided into two type:

1)active maplet
2)Passive maplet

abhishek_upadhyay

 Profile Answers by abhishek_upadhyay Questions by abhishek_upadhyay

• Sep 18th, 2008

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by?keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

Answer Question  Select Best Answer

Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache. Recache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache. Static cache: U can configure a static or readonly cache for only lookup table.By...

adhoc

• Sep 13th, 2011

There are 2 important caches. 1. Static : By default integration service chooses statyic cache.It is read only cache . when you first query the lookup table, it caches the table. whenever a row com...

Mattock

• Sep 7th, 2011

Caches are of following types:
1. Static Cache
2. Dynamic Cache
3. Persistent Cache
4. Non-persistent Cache
5. Shared Cache
6. Un-shared Cache

More types to follow...:-)

Answer Question  Select Best Answer

In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?

Ganesh kumar

• Sep 4th, 2013

Yes, I Agree your answer,.....

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

Connected lookup lends best performance and also you can cache or uncache connected look up unconnected look up is used only when you have to use it as a function call both have its own benefits, using 5 connected lookup's is not a big deal until your mapping is tuned well.

Answer Question  Select Best Answer

John

• May 29th, 2013

Sort all the records by country name. in expr transformation include the below variables v_countout=IIF((v_currcountry=vprevcountry),v_count,vcount+1) basically incrementing the count if the country ...

Mahesh Manam

• May 6th, 2013

Using Router transformation we will achieve this.

S -> SQ -> RTR -> T

In router,create 10 groups for 10 countries

Answer Question  Select Best Answer

Mohan

• Aug 12th, 2018

1. You cannot perform DD_Delete unless you have update strategy.
2. While updating a record, ideally created date should not be changed. for that we definitely have to create two targets (insert and update)

vskogirala

 Profile Answers by vskogirala Questions by vskogirala

• Feb 15th, 2008

In update strategy ,1)An insert in the source an insert in the target2)An update in the source is an update in the target update strategy provides 4 types of data driven functions 1)DD_INSERT2)DD_UPDA...

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

What are the transformations not used in mapplet and why?

Read Best Answer

Editorial / Best Answer

gazulas  

 Profile Answers by gazulas Questions by gazulas

• Member Since Jan-2006 | Jul 2nd, 2008

---

The following should not include in a mapplet.

• Normalizer transformations
• Cobol sources
• XML Source Qualifier transformations
• XML sources
• Target definitions
• Pre- and post- session stored procedures
• Other mapplets

The exact reason i why these should not used i dont know.

sahan

 Profile Answers by sahan Questions by sahan

• Jul 16th, 2009

Normalizer transformationXML source qualifierXML filesOther targets.If
you need to use sequence generator transformation use the reusable sequence gen t/rIf
you need to use stored procedure transformation, make the stored procedure type as normal.

gaurav2485

 Profile Answers by gaurav2485 Questions by gaurav2485

• Jan 8th, 2009

Non reusable Sequencial Generator also we cannot use

Improve Answer

In which situation do we use unconnected lookup?

Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• Jul 4th, 2010

  - when we need to call same lookup multiple times in one mapping.For example in a parent child relationship you need to pass multiple child id's to get respective parent id's- when most...

hundwanipankaj

 Profile Answers by hundwanipankaj Questions by hundwanipankaj

• Apr 6th, 2010

Unconnected Lookup is used when lookup is not used in every reecord. Lookup data is called at the point in mapping that needs it.  It can be used in any transformation that support expression. Us...

Answer Question  Select Best Answer

Target Types are File, Relational and ERP.

Read Best Answer

Editorial / Best Answer

manojkumar_dwh  

 Profile Answers by manojkumar_dwh Questions by manojkumar_dwh

• Member Since Apr-2007 | Apr 14th, 2007

---

PowerCenter can load data into the following targets:

• Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, and Teradata.
• File. Fixed and delimited flat file and XML.
• Application. You can purchase additional PowerCenter Connect products to load data into SAP BW. You can also load data into IBM MQSeries message queues and TIBCO.
• Other. Microsoft Access.

You can load data into targets using ODBC or native drivers, FTP, or external loaders.

saithirumal

 Profile Answers by saithirumal Questions by saithirumal

• Mar 26th, 2011

It may be flat file or relational table.

jayapraveen

 Profile Answers by jayapraveen Questions by jayapraveen

• Oct 4th, 2010

The target types on the server are flat-file, xml, ERP, Cobol etc

Improve Answer

Can identify existing rows of data using unconnected lookup transformation.

Read Best Answer

Editorial / Best Answer

Answered by: SK

• Aug 30th, 2007

---

There are two ways to lookup the target table to verify a row exists or not :
1. Use connect dynamic cache lookup and then check the values of NewLookuprow Output port to decide whether the incoming record already exists in the table / cache or not.

2. Use Unconnected lookup and call it from an expression trasformation and check the Lookup condition port value (Null/ Not Null) to decide whether the incoming record already exists in the table or not.

doppalpaudi

 Profile Answers by doppalpaudi Questions by doppalpaudi

• Jul 9th, 2010

Lookup Transformation is used to cheek weather the data is present in target or not.This transformation is of 2 types 1. Connected lookup transformation2. Unconnected lookup transformation.By using above both we can cheek the target for data .

svivekananda

 Profile Answers by svivekananda Questions by svivekananda

• Jun 26th, 2010

We can use both connected and unconnected lookups to check the existing records in the target table.

Improve Answer

srinivas

• Sep 14th, 2011

In Informatica 8.6, recovery feature is improved. Informatica server writes real time recovery info to a queue which helps maintain data integrity during recovery. So, no data is lost or duplicated. R...

uppala chary

• Aug 28th, 2011

In session properties use session recovery strategy.

Answer Question  Select Best Answer