sm1506

• Apr 8th, 2006

vamshidhar,How do u convert rows to columns in Normalizer? could you explain us??Normally, its used to convert columns to rows but for converting rows to columns, we need an aggregator and expression ...

Vamshidhar

• Jan 11th, 2006

Hi,By using Normalizer transformation we can conver rows into columns and columns into rows and also we can collect multile rows from one row

Answer Question  Select Best Answer

sm1506

• Apr 7th, 2006

Most complex logic we use is denormalization. We dont have any Denormalizer transformation in INformatica. So we will have to use an aggregator followed by an expression. Apart from this, we use most ...

Answer Question  Select Best Answer

Naren

• Mar 29th, 2006

Also known as Junk DimensionsMaking sense of the rogue fields in your fact table..Please read the article http://www.intelligententerprise.com/000320/webhouse.jhtml 

thiyagarajanc

 Profile Answers by thiyagarajanc Questions by thiyagarajanc

• Mar 15th, 2006

Plz explain me Clearly what is meant by Mystery Dimension?

Answer Question  Select Best Answer

Ray

• Mar 22nd, 2006

Always remember when designing a mapping: less for moredesign with the least number of transformations that can do the most jobs.

premlahari

 Profile Answers by premlahari Questions by premlahari

• Dec 13th, 2005

There is no such limitation to use this number of transformations. But in performance point of view using too many transformations will reduce the session performance. My idea is "if needed ...

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 13th, 2006

Complex maping means involved in more logic and more business rules.Actually in my project complex mapping isIn my bank project, I involved in construct a 1 dataware houseMeny customer is there i...

satyam_un

 Profile Answers by satyam_un Questions by satyam_un

• Mar 13th, 2006

Complex mapping  means having more business rules .

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

simply man,Cleansing:---TO identify and remove the retundacy and inconsistencysampling: just smaple the data throug send the data from source to target

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

There is a lot of diffrence between informatica an Ab InitioIn Ab Initio we r using 3 parllalisimbut Informatica using 1 parllalisimIn Ab Initio no scheduling option we can scheduled manully or pl/sql...

Niraj Kumar

• Feb 24th, 2006

in Informatica there is the concept of co-operating system, which makes the mapping in parallel fashionwhich  is not in Informatica

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

ya shoor,Just right click on the particular session and going to recovery optionorby using event wait and event rise

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 8th, 2006

Normalizer: It is a transormation mainly using for cobol sources,it's change the rows into coloums and columns into rowsNormalization:To remove the retundancy and inconsitecy

Answer Question  Select Best Answer

Static cache Dynamic cache U can not insert or update the cacheU can insert rows into the cache as u pass to the target The informatic server returns a value from the lookup table or cache when the condition is true.When the condition is not true, informatica server returns the default value for connected transformations and null for unconnected transformations.The informatic server inserts rows into...

vp

• Mar 6th, 2006

lets say for example your lookup table is your target table. So when you create the Lookup selecting the dynamic cache what It does is it will lookup values and if there is no match it will insert th...

Answer Question  Select Best Answer

U specify the target loadorder based on source qualifiers in a maping.If u have the multiple source qualifiers connected to the multiple targets,U can designatethe order in which informatica server loads data into the targets.

saritha

• Mar 1st, 2006

A target load order group is the collection of source qualifiers, transformations, and targets linked together in a mapping.

Answer Question  Select Best Answer

ravi kumar guturi

• Mar 1st, 2006

it's  very easyActually oracle 8i not allowed userdefined data typesbut 9i allowsand then blob,clob allow only 9i not 8iand  more over list partinition is there in 9i only

Answer Question  Select Best Answer

sathyanath.gopi

 Profile Answers by sathyanath.gopi Questions by sathyanath.gopi

• Feb 27th, 2006

IQD file is nothing but Impromptu Query Definition.This file used for creating cubes in COGNOS Powerplay Transformer.

sathyanath.gopi

 Profile Answers by sathyanath.gopi Questions by sathyanath.gopi

• Feb 27th, 2006

IQD file is nothing but Impromptu Query Definetion,This file is maily used in Cognos Impromptu tool after creating a imr( report) we save the imr as IQD file which is used while creating a cube in power play transformer.In data source type we select Impromptu Query Definetion.

Answer Question  Select Best Answer

madhu sudhan rao

• Feb 18th, 2006

mapping parameters and variables make the use of mappings more flexible.and also it avoids creating of multiple mappings. it helps in adding incremental data.mapping parameters and variables has to cr...

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

in designer u will find the mapping parameters and variables options.u can assign a value to them in designer. comming to there uses suppose u r doing incremental extractions daily. suppose ur source ...

Answer Question  Select Best Answer

Grouping of session is known as batch.Batches r two types Sequential: Runs sessions one after the other Concurrent: Runs session at same time. If u have sessions with source-target dependencies u have to go for sequential batch to start the sessions one after another.If u have several independent sessions u can use concurrent batches. Whch runs all the sessions at the same time.

sangroover

• Feb 15th, 2006

Batch--- is a group of any thing Different batches ----Different groups of different things.

Answer Question  Select Best Answer

For a relational sources informatica server creates multiple connections for each parttion of a single source and extracts seperate range of data for each connection.Informatica server reads multiple partitions of a single source concurently.Similarly for loading also informatica server creates multiple connections to the target and loads partitions of data concurently. For XML and file sources,informatica...

durga

• Feb 13th, 2006

Fine explanation

Answer Question  Select Best Answer

gauravkant

 Profile Answers by gauravkant Questions by gauravkant

• Feb 13th, 2006

Hi,For version control in ETL layer using informatica, first of all after doing anything in your designer mode or workflow manager, do the following steps.....1> First save the changes or new imple...

Answer Question  Select Best Answer

raja rajan

• Feb 7th, 2006

During the execution of workflow all the rejected rows will be stored in bad files(where your informatica server get installed;C:\Program Files\Informatica PowerC...

jawahar

• Jan 30th, 2006

can  you explain how to load rejected rows thro informatica

Answer Question  Select Best Answer

Yes. By using copy session wizard u can copy a session in a different folder or repository.But that target folder or repository should consists of mapping of that session. If target folder or repository is not having the maping of copying session , u should have to copy that maping first before u copy the session

Prasanna

• Feb 3rd, 2006

In addition, you can copy the workflow from the Repository manager. This will automatically copy the mapping, associated source,targets and session to the target folder.

Answer Question  Select Best Answer