Marketing Manager Interview Questions,Faqs

Marketing Manager Interview Questions
1. Have you been a manager of a marketing team in your previous jobs?
2. Have you ever led a team conducting survey analysis and launching new products?
3. How did you correlate your team’s efforts and information? How did this information relate directly to your forecasted objectives?
4. Do you consider yourself a leader? Do you have the drive to lead a marketing team? Can you give examples?
5. What were your marketing goals and objectives?
6. What type of product marketing experiments have you been part of or performed? How did you implement the results?

ETL Dataware housing Interview

What are the various methods of getting incremental records or delta records from the ource systems?

getting incremental records from source systems to target can be done
by using incremental aggregation transformation

How can we use mapping variables in Informatica? Where do we use them?

After creating a variable, we can use it in any expression in a mapping or a mapplet. Als they can be used in source qualifier filter, user defined joins or extract overrides and in expression editor of reusable transformations.
Their values can change automatically between sessions.

Do we need an ETL tool? When do we go for the tools in the market?

ETL Tools are meant to extract, transform and load the data into Data Warehouse for decision making. Before the evolution of ETL Tools, the above mentioned ETL process was done manually by using SQL code created by programmers. This task was tedious and cumbersome in many cases since it involved many resources, complex coding and more work hours. On top of it, maintaining the code placed a great challenge among the programmers.

These difficulties are eliminated by ETL Tools since they are very powerful and they offer many advantages in all stages of ETL process starting from extraction, data cleansing, data profiling, transformation, debuggging and loading into data warehouse when compared to the old method.

How do we extract SAP data Using Informatica? What is ABAP?

What are IDOCS?

Go to source analser ,click on source,now u will get option ‘Import from SAP’

click on this now give your SAP access user,client,password and filter criteria as table name(so it will take lessertime).Afetr connecting ,import the sap source.

Now one important thing after finishing the map save it and generate ABAP Code for the map.Then only workflow will be running fine.

What are active transformation / Passive transformations?

ACTIVE Transformations:Transformations those can affect the number of records between Input and Output.
Passive Transformations:Transformations those do not  affect the number of records between Input and Output.

What is Informatica Metadata and where is it stored?

Informatica Metadate is nothing but the source definition, target definition and the transformations that have been built. They are stored in the respository server and is managed by Repository manager of the informatica client tool.

How do we call shell scripts from informatica?

You can use a Command task to call the shell scripts, in the following ways:
1. Standalone Command task. You can use a Command task anywhere in the workflow or worklet to run shell commands.
2. Pre- and post-session shell command. You can call a Command task as the pre- or post-session shell command for a Session task. For more information about specifying pre-session and post-session shell commands

What is latest version of Power Center / Power Mart?

Latest Ver of Power Center is 7.1 and Informatica stopped marketing powermart product.So right now powermart is not available in market.

Can we override a native sql query within Informatica? Where do we do it? How do we do it?

we can override a sql query in the sql override property of a source qualifier

Can we use procedural logic inside Infromatica? If yes how , if now how can we use external procedural logic in informatica?

We can use External Procedure Transformation to use external procedures. Both COM and Informatica Procedures are supported using External procedure Transformation

Techniques of Error Handling – Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)

Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table.These rejected records we can find in the badfiles folder where a reject file will be created for a session.we can check why a record has been rejected.And this bad file contains first column a row indicator and second column a column indicator.
These row indicators or of four types
D-valid data,
O-overflowed data,
N-null data,
T- Truncated data,
And depending on these indicators we can changes to load data successfully to target.

Performance Testing types

Performance Testing types:

• Component Testing - To find the performance of each component / tier.
• Load Testing - To find out whether the system can handle the expected load upon deployment in production environment.
• Stress Testing - It is performed to find the breaking point of the application. It is a type of testing that measures whether the application’s environment is properly configured to handle expected or unexpected high transaction volumes.
• Volume Testing - To check the stability of the system / application / server with under  large amount of data over extended time periods.

Difference between Functional Testing and Load Testing

Difference between Functional Testing and Load Testing

• Functional testing - to check the functionality – To check the functionality of business processes
• Load / Performance testing - to check Stability, Performance, Functionality under load. Examples:
  • Will 1000 concurrent hits crash the server or application?
  • Is response time is as per the specifications?

smalltalk interview faqs

1. What was the original assignment operator in Smalltalk-80?

2. What does the #at: method of a collection class return?

3. What does the #at:put: method of a collection class return?

4. What is a "first class object"?

5. Tell me about block variables, arguments, and scope of variables.

6. Explain smalltalk mathematical notation, including order of operations and 
 the reasons.

7. Why can't you do recursion in Smalltalk?

8. What is the difference between an instance variable, a class variable, and 
 a class instance variable?

9. Describe indexed instance variables vs. named instance variables.

10. How do you access indexed instance variables?

11. What is a meta-class, and what objects are instances of meta class?

12. What is an abstract class?  Can you name an example in Smalltalk?

13. How does Smalltalk support multi-tasking?

14. Name some examples of how Smalltalk is oriented toward single users?
How can these problems be approached or overcome?

15. Suppose you were offered the choice of two tasks with the same tight deadline:
                                (1) Write a Smalltalk to C++ cross compiler
                                (2) Write a C++ to Smalltalk cross compiler.
                     
                        Which task would you choose and why?

16. Name some of Smalltalk's shortcomings.

17. What is the value of n after the following code is executed? 
                 | n |
                 n := Dictionary new.
                 n at: #one put: 1.
                     
                 Evalutate the coding style of the above Smalltalk code.

18. In which of the following languages can the programmer know the type of 
 data a variable will refer to at runtime:
                        C, C++, Smalltalk

19. Which of the following phrases could be applied to Smalltalk?
untyped, statically typed, dynamically typed, strongly typed, weakly typed 

20. What is meant by the word "binding" with respect to data elements?

21. Most people would agree that it is inherently easier to implement a 
 Dictionary class in Smalltalk than in C/C++.  Any reasonable C++ 
 implementation would also be trickier to use.  Why?

Video interview questions

Video Interview Questions and Tips

Technology is invented to make life simpler and advanced. Video interview questions present a perfect solution if you want to attract your employer effectively. Video interview is a very effective solution for employers if they are recruiting candidates for a global work place. Video interview saves transportation costs and it makes recruiting much more fun. For recruiting agencies or companies it can add an extra advantage as they can record the whole process and show it to their clients.
For a job seeker it provides a challenge although they are familiar with the technology. Questions asked will be have a similar resemblance to the ones which are asked during face to face interview (one-one interview) the only difference lies in answering them in front of a camera with a head phone. It also tests your body language and if you have applied for a position which has strong presence in the service sector then importance will be placed on facial aspects and soft skills.
Although you can have a video conference scheduled in your home many companies prefer to have them either in a recruiting firm or in a company which provides these facilities. It requires the same amount of professionalism which is required in a one to one interview session. Generally video interview is conducted as the last phase where you will have the chance to interact with the overseas client directly so make good use of it.
Some of these tips should help you out during a video interview they are: -
1) Planning is crucial do contact the company or its facilitator whether they require any information prior to the interview.
2) Don’t be late to the interview because you may never know to whom you will be speaking with. He can be the chief of your company also.
3) Ask for basics on how to use the equipment even if you know how to handle it.
4) Dress professionally as you would dress for an in-person interview. Don’t be on a wrong assumption that the interviewer will be having a half-length view of your body.
5) Only have important papers, pen and a glass of water on your work station which will have a professional look.
6) A microphone picks up even minute sounds so don’t make any sounds, tapping, etc.
7) Eating, chewing, smoking, etc during the interview process are negative habits and they should be avoided at any cost. They distract you and the interviewer.
8) Eye to eye contact is very necessary during the entire duration of the interview.
9) If there is a feature such as picture in picture then it is better to turn it on also it shows your looks.
10) All the questions which will be asked during the in-person interview will be asked in the video. Try to have answers to all of them before hand. Difference lies in the fact that you will be speaking with the client directly. Ask questions if you have any. Prior information on how long the interview session might last could help you in planning for the interview. All this process should be viewed as a step towards getting hired.
11) Technical interviews will test on your technical knowledge make sure that you are thorough with the basics and most of the companies ask you basics. If you do not know answer to a specific question tell them that you don’t know the answer to that specific question it is no harm but if you try to attempt it with having knowledge it will have a catastrophic effect.
Some of the basic questions you need to know are as follows: -
1) Project details, its uses and benefits, environment, team, client name?
You need to be as detailed as you can about these specific questions as they will decide your future job prospect and opportunity.
2) Are you passionate about open content and open source project?
State whether you are passionate about them and your contributions to the society. Also tell them whether you like to develop open source projects or proprietary projects and state the reason.
3) What do you know about this company, your job opening and explain about the possible job environment?
While answering this question make sure that you do enough research about the company and your job opening. It is imperative that you know about the job, its environment, technical aspects and possibly what type of projects you would be working with then do explain to him about all these.
4) State a major problem you faced during the project in detail and explain us how you approached it and solved?
While answering this question you need to be honest. If you do not know enough about the project then politely address the basics. Remember they know much more about the technicalities than you don’t try to fool them.

Phone interviews--How to handle

Generally phone interview is used as a screening process for final interview or in face interview. Process of conducting interviews through telephone is increasing by day and companies do often get their candidates during this initial phase. This process also reduces expenditure of the company. Patience level exhibited by recruiters on telephonic interview is minimal if you have

• Poor communication skills
• No command on the language
• Lack of technical skills
• Low grasping capabilities

These defects are prime concern for an interviewer and the worst part is you may never know when you would be receiving the call. Be prepared for the call always when you have applied for one.
There are also benefits with this process to the candidate they are
• One can attend the interview in his comfort zone.
• He can comfortably speak irrespective of the concerns for body language, clothing, etc.
• Have technical help with him during the process of interview.
• Can make good use of his communication skills without being afraid of one-one interview sessions.

When you are attending a telephonic interview you would get only few minutes to express about yourself and your technical capabilities. Make sure that you speak to the interviewer clearly and in audible tone.
Some of the things which you should have on your desk are

1) An updated resume which contains all the information about your project.
2) Project report and a short list of accomplishments
3) Have a Pen and paper handy for jotting down any important piece of information.
4) Call waiting should be turned off.
5) Be free from external noise turn off your stereo or music player, tell your family and friends to stay put for sometime, Shut the dog, etc.
6) Make sure that you avoid cell phone and prefer a landline instead because a cell phone can have a dropped call, a static influence, etc.
7) Have all the things spread on your desk which are deemed to be important. Most importantly be far from distractions.

Interview determines your career progress and it details about your job prospects. There are some dos and don’ts which should be taken care of during the interview they are
1) Avoid chewing gum, smoking, drinking, eating, etc during the interview.
2) Have some water beside you incase you need to wet your mouth.
3) Smiling has a profound effect which makes you and the interviewer comfortable. Make sure you develop a habit of smiling because it will help you in your interview.
4) Speak clearly, slowly, and explain to him in a pleasant tone.
5) Use Mr. or Ms and if you know their last name then use it.Ask for permission if you need to use their first name.
6) Never ever interrupt while some one is talking which applies here also.
7) Short answers are best answers be specific wherever requested.
8) Don’t rush go slow take a moment to think about the answer.
9) Ask for a face to face interview whether it is possible to have one scheduled.
There are telephone`s ethics which should be followed during the conversation because it makes you professional make sure that you follow.
Here are sample phone interview questions: -
1) Explain about your past work experience?
When you are answering this question make sure that you speak about your past experience. Don’t fumble or get nervous while answering this question.
2) Explain about all the job responsibilities you have undertaken?
Make sure that you have your resume in front of you to tell the employers about all the work you have undertaken so far and the job responsibilities you have undertaken.
3) Explain about the most challenging project you have undertaken?
When answering this question make sure that you have a rough abstract of the project report before you. This makes your work simpler rather than recollecting it. Technical specifications should be explained as clearly as possible. Deadlines, key points, specifications, etc should be explained very clearly.
4) Any extracurricular activities you undertook?
Make sure that you explain all the extra curricular activities you have started or participated in your employment. Have some papers or certificates which can suffix that. These activities are important because they can show your team play and leadership skills.
5) What is your goal after five years from now?
Explain to the interviewer about how you would see you’re self after five years from now. You can speak about your long term goals and short term goals. Also state whether you would like to learn any language or specific skill during this period.
6) What do your employers say about you?
State positive attributes about yourself and also remember that we do have our negatives just state some of them which you would like to stop or reduce. Employers like to always have neutral employees rather than over positive or negative people around them. Try to be calm, neutral and honest
7) What are all the languages or skills you have with our current opening?
This is a chance to express about you. Make sure that you explain to him about skills you have which might not be relevant to the current opening but they will have long term benefits when you are selected. If you are not selected then you will have an edge when those skills are required by the employer.

Robustness Testing for PT(Protocol testing)

Robustness Testing for PT(Protocol testing)

Robustness Testing - process of subjecting a device under test to particular input streams. The input streams may be one of three types:
·    Random input streams
·    Valid input streams
·    Invalid input streams
Robustness testing is a form of security testing. Security testing is more broadly defined to include monitoring / surveillance and the detection of specific exploits like IP spoofing or phishing etc.
The example of intelligent robustness test can be adding a trailing dot to the DNS name in the SIP URL. This is legal, but perhaps unexpected. The SIP implementation in the receiving device should process this correctly.
Keywords:
sw robustness test
robustness test example
robustness test spss
robustness testing cyber security
conduct robust testing scenarios
how to check the robustness of a website
robustness meaning in computer science
types of robustness checks

Line speed testing for PT(protocol testing)

Line speed testing for PT(protocol testing)

Line Speed Testing - process of verifying that a device can operate at its rated line speed, when the bandwidth is 100% utilized or saturated.
For example, if the device is rated as operating at 5 Giga bytes per second, then the device should be able to handle incoming traffic utilizing all the available bandwidth.
Keywprds:
submaximal exercise testing protocol
sppb score results
sppb score meaning
submaximal testing
sppb scoring
submaximal exercise examples
submaximal exercise testing: clinical application and interpretation
maximal vs submaximal fitness testing