What is the diffference between SQL override and SQL transformation ?

Bilal

• May 7th, 2013

There is no different between them. The only thing is, SQL override is executed at the beginning of a mapping and the SQL-Transformation is executed downstream of the mapping

Answer Question  Select Best Answer

Kevin B

• Jul 8th, 2005

Download the Document

Kevin B

• Jul 8th, 2005

The Informatica? PowerCenter? Partitioning option optimizes parallel processing on multiprocessor hardware by providing a thread-based architecture and built-in data partitioning. GUI-based tools...

Answer Question  Select Best Answer

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 24th, 2006

Run a stored procedure before or after your session.Unconnected Run a stored procedure once during your mapping, such as pre- or post-session.Unconnected Run a stored procedure every time a ...

sangeetha

• Sep 26th, 2005

Unconnected:The unconnected Stored Procedure transformation is not connected directly to the flow of the mapping. It either runs before or after the session, or is called by an expression in another t...

Answer Question  Select Best Answer

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

The db2 date formate is  "yyyymmdd"  where as sysdate in oracle will give "dd-mm-yy" so conversion of db2 date formate to local database date formate is compulsary. other wise u will get that type of error

Sitaram Yarlagadda

• Nov 23rd, 2005

Use Sysdate or use to_date for the current date

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,see informatica is basically a integration tool.it all depends on the source u have and ur requirment.if u have a EMS Q, or flat file or any source other than RDBMS, u need info to do any kind of a...

Rishi

• Dec 5th, 2005

It depends upon our requirment only.If you have good processing database you can create aggregation table or view at database level else its better to use informatica. Here i'm explaing why we need to...

Answer Question  Select Best Answer

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,what ever said by rishi is correct,info can be used as a cleansing tool.usually EXP is used for cleaning data using data cleansing functions and other functions present in infa.eg,assign default va...

Rishi

• Dec 5th, 2005

Yes, we can use Informatica for cleansing data. some time we use stages to cleansing the data. It depends upon performance again else we can use expression to cleasing data.For example an feild X...

Answer Question  Select Best Answer

srinivas vadlakonda

• Sep 28th, 2006

Incremental aggregation is in session properties i have 500 records in my source and again i got 300 records if u r not using incremental aggregation what are calculation r using on 500 records again ...

gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

its a session option. when the informatica server performs incremental aggr. it passes new source data through the mapping and uses historical chache data to perform new aggregation caluculations incrementaly. for performance we will use it.

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

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,we can stop it using PMCMD command or in the monitor right click on that perticular session and select stop.this will stop the current session and the sessions next to it.

vasulu

• Feb 17th, 2006

we have a task called wait event using that we can stop.we start using raise event.this is as per my knowledge.

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

Shanmugam

• Jul 6th, 2006

The only two possibilities as of I know isBoth the table should have primary key/foreign key relation shipBoth the table should be available in the same schema or same database

geek_78

 Profile Answers by geek_78 Questions by geek_78

• Feb 18th, 2006

We can connect two relational table in one sq Transformation.No errors will be performRegards,R.Karthikeyan

Answer Question  Select Best Answer

manikandan1982

 Profile Answers by manikandan1982 Questions by manikandan1982

• Feb 21st, 2006

You can select these details from the repository table.  you can use the view REP_SESS_LOG to get these data

rajarajana

 Profile Answers by rajarajana Questions by rajarajana

• Feb 15th, 2006

When your workflow get completed go to workflow monitor right click the session .then go to transformation statistics ther we can see number of rows in source and target.if we go for session properties we can see errors related to data

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

vizaik

 Profile Answers by vizaik Questions by vizaik

• Apr 11th, 2007

For a project, there will be: 1.BRD(Business Requirement Document)-BA 2.SSSD(Source System Study Document)-BA BRD consists of the requirements of the client. SSSD consists of the source system study...

Answer Question  Select Best Answer

girish

• Mar 16th, 2006

Use sequence genetrator transformation

Sudip

• Mar 10th, 2006

if data in tables as follows Table AKey-1 char(3);table A values_______123Table Bbkey-a char(3);bcode  char(1);table b values1 T1 A1 G2 A2 T2 L3 Aand output required is as1, T, A2, A, T, L3, Athe...

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

kalyan

• May 1st, 2006

To flag source records as INSERT, DELETE, UPDATE or REJECT for target database. Default flag is Insert. This is must for Incremental Data Loading.

satyambabu

• Mar 22nd, 2006

Maintain the history data and maintain the most recent changaes data.

Answer Question  Select Best Answer

srinivas vadlakonda

• Sep 28th, 2006

If u r taking the dimension table it has the master data like product id, product name, product description dimention are three types conformed dimention, junk dimention and  degenerate dimention.If u r taking facttable it contains the measures like sales revenue,price  and discount.

ravi kumar guturi

• Mar 17th, 2006

In the fact table contain measurable data and less columns and meny rows,It's contain primarykeyDiffrent types of fact tables:additive,non additive, semi additiveIn the dimensions table contain textual descrption of data and also contain meny columns,less rowsIts contain primary key

Answer Question  Select Best Answer

raghavendroa

 Profile Answers by raghavendroa Questions by raghavendroa

• May 3rd, 2006

1.union & custom transformation2.lookup on flatfile3.we can use pmcmd command4.we can export independent&dependent repository objects5.version controlling6.data proffiling7.supporting of 64mb architecture8.ldap authentication

sn3508

 Profile Answers by sn3508 Questions by sn3508

• Apr 4th, 2006

I'm a newbie.  Correct me if I'm wrong. In 7+ versions - we can lookup a flat file - union and custom transformation- there is propogate option i.e, if we change any datatype of a ...

Answer Question  Select Best Answer

can any body tell me the configuration of informatica in UNIX, or if it is difficult to explain please send the doc. thanks in advance

raju

• Jul 25th, 2006

hi jagadeeshi want to know the informatica installation proceedure on unix or linux . i want to try for my sake only. if u have just forward it .  like step by step proceedure i want . in the manuals it is not giving clear idea that's whyfromraju

jagadeesh

• Apr 3rd, 2006

Hiin unix enviromment if u install informatica means... u need one more machine to connect to that server.Since GUI is not there in unix env...SO no one will prefer unix env....If  u r in project...

Answer Question  Select Best Answer