diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
2 7218Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
2 9085I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
6 12577I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
2 13842Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...
6 13201Whether availability check will be carried out for make to order and make to stock? If it happens why?
3 8035i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.
5 121051. Consider the following code in our example assembly language: ; an example bit of assembly code ROOT: W FATHER FATHER: W SON1 W SON2 SON1: W NIL W NIL ; ---------------------- SON2: W GRANDSON W NIL GRANDSON: W NIL W NIL NIL = 0 Assemble this code carefully following the two pass model, and show the symbol table at the point marked by the dashed line during each pass.
2363After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
3 8877In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
2 11936Post New TCS Interview Questions
Many of the groups of elements in the periodic table have acquired common names. The elements in group ia, with the exception of hydrogen, are called what?
How do I create a link to a file?
What the difference is between a database, a data warehouse and a data mart?
List down the major benefits of using node.js?
What is the connector?
What are the Types of Useful node functions?
How x-csrf-token is different from csrf tokens?
What is a web server in client server environment?
give the syntax of grant and revoke commands? : Sql dba
How to write date and time interval literals in oracle?
Explain about message listeners?
What is indexer c#?
Which database is best with python?
What are the jobs involved in replication process?
Explain api.php route.