what are variable ports and list two situations when they
can be used?
- 4 Answers
- 13967 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / maruthi
VARIABLE PORT-WHCIH WE CAN CREATE IT IN MANY
TRANSFORMATIONS FOR VARIABLE CALCULATION PURPOSE.
CREATE ANY NEW PORT IN AGGREGATION AND USE IT TO
CALCULATE MAX(SAL) OR ANY OTHER CALCULATION,THEN IT BECOMES
VARAIBLE PORT.
IT IS CALLED AS VARABLE PORT ,BECOAUSE IT IS VALUE WILL BE
KEEP ON CHANGING AS THE ROWS ARE KEP ON CHANGING.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is the difference between cubes and package in cognos
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
if i have a query as flat file how can we load data to target table
How to increase performance without changing anything in mapping.( In prod)
what is the difference between cardinality and Nullability?
What is cube grouping?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is partitioning? Explain about round-robin, hash partitioning.
What is tracing level and what are the types?
Explain different types of partitioning?
what is different between sequential batch and concurrent batch and which is recommended and why?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
List few etl bugs?
