Interested to Buy Any Domain ? << Click Here >> for more details...
how do u set the size of block buffer?
- 1 Answers
- 4417 Views
- I also Faced
- E-Mail Answers
Answer / sarvesh
go to edit properties in any of the following trans like
rank,lookup,joiner,aggregator,there u can change the size
of buffer,but by dewfault it is 64kb.
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
What is partitioning? Explain about round-robin, hash partitioning.
What are the three tiers in etl?
can be used COM component in Informatica ?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
State the differences between shortcut and reusable transformation
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Teradata 
